Answered

Problems with using Smartsheet insert row () from Power Apps

(0) Share

Report

Posted on by SM_Trailhead

Hi - I have a Power App where i am assembling data to insert new row in SmartSheet and continue to struggle to pass a record successfully to insert into my sheet.

Here is the code I am using and receiving the following: Invalid argument (Table) Expecting Untypedobject... I am new to Power App and know that the collect is probably not right approach and hoping this group can assist.

// Try this structure to pass to smartsheet directly from this OnSelect:
Collect(rowProjHours, {ProjectID: selProject, Hours:txt_hours.Text, WorkItemDesc: txt_workdescription.Text, MilestoneDeliverable: txt_milestonedeliverabledesc.Text, Resource:ddl_resource.SelectedText.Value, IncludeClientInvoice: chk_includeclientinvoice.Value });

Smartsheet.InsertRow(selProject.id,rowProjHours);

Thanks in advance!

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @SM_Trailhead ,

Please try to pass the value to flow and use flow to insert data into the sheet.

'PowerAppV2->Insertrow'.Run( JSON( [{'Primary Column':"Test1",'Column2':"Test2"},{'Primary Column':"Test3",'Column2':"Test4"},{'Primary Column':"Test5",'Column2':"Test6"}],JSONFormat.Compact))

Best Regards,

Wearsky
SM_Trailhead 37 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Wearsky,

Thank you so very much for detailed instructions. I was able to reproduce your example above and works very well. Where the solution for my client breaks down, is when I need to pass the Sheet Id dynamically from the Power Apps OnSelect. Basically I need to pass the Sheet ID as well as the columns in the sheet. The columns would definitely be consistent across any sheet ID that is passed in to the flow. When I tried to extend your solution to include that input, I couldn't figure it out.

I receive "Unable to parse insert row request payload."

I am grateful for the support of this community! Thanks
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @SM_Trailhead ,

Please try this

'PowerAppV2->Insertrow'.Run("4226679132082052",JSON([{'Primary Column':"Test1",'Column2':"Test2"},{'Primary Column':"Test3",'Column2':"Test4"},{'Primary Column':"Test5",'Column2':"Test6"}],JSONFormat.Compact));

Best Regards,

Wearsky