How do I use Smartsheet connector in Power Apps?

granpa_chair

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.

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.

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.

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

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

Thank you! It did help!