web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Smartsheet Insert Row ...
Power Automate
Unanswered

Smartsheet Insert Row - Floats changing to Strings?

(0) ShareShare
ReportReport
Posted on by

I'm struggling to figure out how to write a float into Smartsheet using the Insert Row connector.  When the value being input is a float, it always outputs as a string.

 

Input:

DCTMK_0-1659119205317.png

Output:

DCTMK_1-1659119273090.png

 

I've searched for a way to do this for several months, so any guidance would be greatly appreciated!

Categories:
I have the same question (0)
  • Rhiassuring Profile Picture
    8,690 Moderator on at

    Did you happen to review this thread? https://powerusers.microsoft.com/t5/Using-Flows/Adding-numbers-to-a-row-in-SmartSheets/td-p/733864  - it seems like SmartSheet tries to copy it across while adding an apostrophe, so the solution here was to use a formula to substitute the added '.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Expiscornovus Profile Picture

Expiscornovus 201 Most Valuable Professional

#2
David_MA Profile Picture

David_MA 174 Super User 2025 Season 2

#3
harshdeol Profile Picture

harshdeol 167 Moderator

Last 30 days Overall leaderboard