cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
seussiii
Advocate I
Advocate I

SP item format help

I have a calculated column formatted as currency with 2 decimal places. When "sending email with options" I reference that SP item to give the total but that formatting doesn't seem to carry over.

 

SP value is $184.65 but when the email is received it displays 184.650000000000

 

thoughts?

1 ACCEPTED SOLUTION

Accepted Solutions

Under the expression tab

 

Enter float() then click dynamic content and map your dynamic value.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

4 REPLIES 4
abm
Super User
Super User

Hi @seussiii 

 

Could try using expression float()

 

image.png

 

Run result

 

image.png



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

how would I use that with a dynamic total since there will potentially be several entries on the SP list? @abm 

Under the expression tab

 

Enter float() then click dynamic content and map your dynamic value.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

Hi!

So on your email body you display several items from your sharepoint list?

If so, I assume you are applying some sort of filter to 'Get items' action block, so you get at least one item as result. No matter you get 1 or N items, they are elements of an array.

Then you can just add a Select action block, assigning this filter output as its input.

On Select mapping table, you can add on the left side the name of the column you wish to be used, and on the left the expression @abm suggested.

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,811)