cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
andrew_wm
Frequent Visitor

Leading 0 being removed from a decimal value after formatting

Hello all,

I'm trying to get a KPI bot to display the proper number when sending the message through teams, which looks like this:

wrong decimal value.PNG

However, it looks like this in Power BI:

how it should look.PNG

I'm using the Format Number function in PA to convert the float into 2 decimal places as required, yet it still removes the leading 0.

flow.PNG

 

Using the 'create expression through example' option for the format does not work either, as it will either add a random non-specified number to the value, or not work at all.
Does anyone have any solutions to this? I'd be very grateful for any help





1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

Hi @andrew_wm ,

 

I made a sample for you:

 

Enter custom value in Format.

 

 

Enter '#0.00'.

vxiaochenmsft_1-1670376279389.png

 

 

Save and run flow. The result retains the leading 0.

vxiaochenmsft_2-1670376279391.png

 

Best Regards,

Wearsky

View solution in original post

2 REPLIES 2
v-xiaochen-msft
Community Support
Community Support

Hi @andrew_wm ,

 

I made a sample for you:

 

Enter custom value in Format.

 

 

Enter '#0.00'.

vxiaochenmsft_1-1670376279389.png

 

 

Save and run flow. The result retains the leading 0.

vxiaochenmsft_2-1670376279391.png

 

Best Regards,

Wearsky

Hey, thanks for the reply

 

And no way it's that easy...

You're a genius thank you so much, it worked perfectly

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,570)