Formatting various value fields

(0) Share

Report

Posted on by LorraineHowie

Hi, I am a self taught power automate user and am trying to do the following.

I have a Microsoft form set up as an order form for catering services. The order is transferred to a SharePoint list where I have additional columns which calculate total costs.

I want to use power automate to take these figures and format them into an email to send back to the person placing the order showing the total due.

I can format a figure to show the currency amount which I can add to the body of the email (cant get it to add to an attachment without showing B#123 instead of £123). Is there anyway to format figures from multiple columns at once or do I need to create steps for each of the column figures?

Any advice gratefully received

All responses (1)

Answers (1)

Verified answer

v-bofeng-msft on at

Like (0)

Report

Re: Formatting various value fields

Hi @LorraineHowie ,

I've made a test for your reference:

I assume there is a table 'TheArray'

Using select to format the columns

Result

Best Regarsd,

Bof