When I move numbers from my flow into Smartsheet, instead of 0.5, for example, it shows as '0.5
This is a concern because I want to use a formula in Smartsheets, but in its current state I am stuck with having to manually go in and delete the ' from each cell. Any solutions out there? Thank you!
Can you show your flow? If the ' doesnt exist in your data and is coming up in flow its quite possible that you might have a extra character some where.
Please click Accept as Solution if it resolved your problem or give it a Thumbs Up if it helped you in anyway this will allow other people to search correct solutions effectively.
Yeah here it is @Rahber
Name: Date Diff Ticks
Name: Difference Seconds
Value: div(variables('DateDiff Ticks'),10000000)
Name: Difference Hours
Value: div(variables('Difference Seconds'),3600.00)
I saw that you are calculating the different hours which is a string type variable. The issue may caused by the formula in the Initialize variable 3 action. Please:
1. Initialize variable 3 formula -
That's really weird.
However, why not have some tests?
Check out new user group experience and if you are a leader please create your group
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
Many congratulations to the Season 1 2021 Flownaut Crew!
ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.