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"
}
]
}
)
Best Answer
-
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.
Answers
-
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.
-
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)
-
Thank you! It did help!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives