How to format "row" when inserting record into Smartsheet

Hi - i have a Power App where i am assembling data to insert new row in SmartSheet and continue to receive "unable to parse insert row request payload". I have formatted the row via "Compose" action a few different ways to no avail.

Here is latest attempt - note that I am replacing the variables('... using dynamic content and I tried just using the below - same results.

Any help would be greatly appreciated!

[ { "ProjectId":variables('ProjectID'),

"Bill item description":variables('Bill item description'),

"Associated Milestone/Task item/Deliverable":variables('Associated MilestoneTask itemDeliverable'),

"Bill Type":"Hourly Rate",

"Recipient":variables('Recipient'),

"Include in invoice to client?":variables('Invoice client'),

"Resource":"shannonmoran@trailheadstrat.com",

"hourstaging":variables('Invoice client')

}]

Find more posts tagged with

Accepted answers

All comments

Genevieve P.

Hey @SM_Trailhead

If you don't receive a response from other Smartsheet users, you may want to post this question in the Microsoft Power Apps Community as those users may be more familiar with Power App syntax and structure.

Cheers,

Genevieve

Kelly Moore

Hey @SM_Trailhead

I'm not sure if it is the same, but I had to figure out a similar problem when using power automate to insert excel row into smartsheet. I had to use a JSON array to solve it. Perhaps this will help:

https://community.smartsheet.com/discussion/105052/power-automate-smartsheet

Good luck

Kelly

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.