cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

Converting string to int - can't use formatting?

I have a calculated column that is giving me say 100.00 as a number in a flow email.  I've converted that from a string to a int and then used Format Number so it now shows 100.  That is working.  I'm now wanting to add some formatting (bold and color to the font) and it's giving me an error

 

Unable to process template language expressions in action 'Send_an_email_(V2)_NOT_MET' inputs at line '1' and column '2875': 'The template language expression 'body('Format_number')?['body']' cannot be evaluated because property 'body' cannot be selected. Property selection is not supported on values of type 'String'. Please see https://aka.ms/logicexpressions for usage details.'.

 

I believe this should be doable so any thoughts?

 

 

I have a Compose that brings in my calculated column

I have a 2nd Compose that is  "int(outputs('Compose_5'))"

I then use Format Number to takes that 2nd compose and formats it as ###

 

Everything works until I highlight formatted number and add color or bold to it.  Thoughts?

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @bryanc78,

 

You could set the Send Email body to HTML view, then use the <b> tag and style to bold it and color it.

Screenshot 2020-09-24 171423.jpg

Screenshot 2020-09-24 171216.jpg

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Community Support
Community Support

Hi @bryanc78,

 

The error is property 'body' cannot be selected, it will occur when some property in the output of action not exists, could you please share a screenshot of your Flow configuration?

And could you please share the formatting (bold and color to the font) setting? With picture could help us assist you better.

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-litu-msft 

 

Here you go

 

Compose 5 - calculated column

Compose 6 - int(outputs('Compose_5'))

Format Number - output is Compose 6

 

To format ,I'm just highlighting Formatted Number in the body of the email and using the format tool bar to add color and to bold it

 

 

 

bryanc78_0-1600866621360.png

 

 

 
 
 
 

2020-09-23_8-12-38.png

 

 

Hi @bryanc78,

 

You could set the Send Email body to HTML view, then use the <b> tag and style to bold it and color it.

Screenshot 2020-09-24 171423.jpg

Screenshot 2020-09-24 171216.jpg

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

@v-litu-msft 

 

Thank you, that worked.

 

It is annoying though that every time I make a change to the email, I have to remove Formatted Number and re-add it

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (66,370)