How do I use Smartsheet connector in Power Apps?

granpa_chair · 08/22/24

Hi,

How do I use Smartsheet connector to Insert Row in specific Sheet?

Documentation is quite poor and don't know how to pass values properly. Code that I use is below. How do I fix it to make to make it work?

Smartsheet.InsertRow(    "192045464213123";    

                                       {        

                                           [            

                                               {                

                                                   "columnId": 4266183311445892,                

                                                   "value": "TEST",                

                                                   "displayValue": "TEST"            

                                               }        

                                            ]   

                                       }

)

Corey W. · 08/26/24

I will say it is way easier to use power automate to insert rows and call the flow from your app.

To get the connector to work directly in Power Apps I had to use the ParseJSON function to build the row I wanted to insert:

Set(varthing,ParseJSON("{ ""Primary Column"": ""0"", ""Index"": 1, ""Date Submitted"": ""04/10/24 4:54 PM"", ""Change Type"": ""Unsubscribe"", ""Name"": """&TextInput1_1.Text &""", ""Email"": ""something"" }"))

then pass the variable (varthing) into the connector:

Smartsheet.InsertRow(6974482061152132,varthing)

It is possible there is another way but I haven't figured it out.

Corey W. · 08/26/24

I will say it is way easier to use power automate to insert rows and call the flow from your app.

To get the connector to work directly in Power Apps I had to use the ParseJSON function to build the row I wanted to insert:

Set(varthing,ParseJSON("{ ""Primary Column"": ""0"", ""Index"": 1, ""Date Submitted"": ""04/10/24 4:54 PM"", ""Change Type"": ""Unsubscribe"", ""Name"": """&TextInput1_1.Text &""", ""Email"": ""something"" }"))

then pass the variable (varthing) into the connector:

Smartsheet.InsertRow(6974482061152132,varthing)

It is possible there is another way but I haven't figured it out.

Corey W. · 08/26/24

Hi,

I will say it is way easier to use power automate to insert rows and call the flow from your app.

To use the connector directly in powerapps, I had to use the ParseJSON function first to build the row I planned to insert:

Set(varthing,ParseJSON("{ ""Primary Column"": ""0"", ""Index"": 1, ""Date Submitted"": ""04/10/24 4:54 PM"", ""Change Type"": ""Unsubscribe"", ""Name"": """&TextInput1_1.Text &""", ""Email"": ""something"" }"))

Then pass that variable to the Smartsheet connector:

Smartsheet.InsertRow(6974482061152132,varthing)

granpa_chair · 08/27/24

https://community.smartsheet.com/discussion/comment/451185#Comment_451185

Thank you! It did help!

How do I use Smartsheet connector in Power Apps?

Best Answer

Answers

Categories