You’re offline. This is a read only version of the page.
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 @eizk
You could use formatNumber function to get 2 decimal places:
Share
Report
All responses (
Answers (
formatNumber(float(first(split('1.1 xxxx',' '))),'#.00')
If this helps & solves your problem, please remember to give a đź‘Ť and accept my solution as it will help others in the future.
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 @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
#1
WarrenBelz
146,658
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
