Notifications
Announcements
Hi All.
My requirement is to convert string numbers to decimal numbers in Power Automate flow, Is there any way to do this? Please Help me!
I tried with the value() function it works in Power Apps and not in Power Automate.
Thanks,
@Anonymous
Hi @Anonymous
Pls use float function.
As an example, float('5.0') will convert string 5.0 to decimal number.
If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
Thanks
Hi,I have file names (string) as such which I used split function to get the numbers using ' ' as separator. However using float or decimal function will only output the number up to 1 decimal place.
1. 1.0 xxxx
2. 1.1 xxxx
3. 1.10 xxxx
4. 1.12 xxxx
Cant seem to work with format number from strings too.
Hi @eizk
You could use formatNumber function to get 2 decimal places:
formatNumber(float(first(split('1.1 xxxx',' '))),'#.00')
I got the answer now. 1.10 is just 1.1. I would recommend naming the file to x.01 instead of x.1.Thank you.
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 501 Super User 2025 Season 2
Tomac 323 Moderator
abm abm 237 Most Valuable Professional
