Skip to content
  • Try Smartsheet

    • Add Ons and Integrations

    Add Ons and Integrations

    Ask questions about Control Center, Dynamic View, DataMesh, Pivot App, Calendar App, or WorkApps. Discuss connecting Smartsheet to your other systems with integrations such as Bridge, Data Shuttle, the Jira connector, and the Salesforce connector.

    How do I use Smartsheet connector in Power Apps?

    ✭
    edited 08/22/24 in Add Ons and Integrations

    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"            
    
                                               }        
    
                                            ]   
    
                                       }
    
)
    · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Best Answer

    • ✭✭✭✭
      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.

      · Share on FacebookShare on Twitter

    Answers

    • ✭✭✭✭
      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.

      · Share on FacebookShare on Twitter
    • ✭✭✭✭

      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)

      · Share on FacebookShare on Twitter
    • ✭
      Corey W.

      Thank you! It did help!

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Quick Links

    Categories

    Trending Posts

    Help shape the future of Smartsheet.
    Share your ideas and feature requests.

     Watch video