When Power Automate inserts data in Smartsheet, how to work correctly with formatted columns?

I have a Microsoft Form that my sales team fills out when they win an order. I have created a Power Automate flow to create a new line in Smartsheet and insert this data. I am using MS Forms + Power Automate and not Smartsheet's form because it also performs other actions outside Smartsheet.

However, on the columns that are "Sale Value" and "GP %", they are formatted as dollar value and percentage, see below. Power Automate inserts the data in these columns as a string and I have to remove an apostrophe to display correctly.

Is there a way to have Power Automate insert this data correctly?

Thanks!

Find more posts tagged with

API and Developers

Integrations

Automations

Workflows in Smartsheet

Accepted answers

All comments

ro.fei

I would try using "Format data by examples" within Power Automate to eliminate the ' & see if that works. Let me know if it works, if not I'll help you brainstorm another workaround!

Brant F.

Ok, I just tried Format data by examples, but it didn't work. Do you have a particular example that works?

I have tried a few but it still inputs the data in Smartsheet as a string with a ' at the beginning.

These were all inserted as strings.

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.