How do I use Smartsheet connector in Power Apps?

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"            

                                               }        

                                            ]   

                                       }

)

Find more posts tagged with

Accepted answers

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.

All comments

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:

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:

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.