cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Send mail failing with format numbers

Hi,

 

My Send Mail action fails because output of Format numbers cant be processed, message error:

 

Unable to process template language expressions in action 'SendVerificationRequest_2' inputs at line '1' and column '2803': 'The template language expression 'body('TotalOver8')?['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.'.

 

Here is my TotalOver8 number format flow step:

 

totalover8.PNGAny ideas what might be the issue? It seems to be working just fine on friday.

1 ACCEPTED SOLUTION

Accepted Solutions
SamPo
Power Participant
Power Participant

@Anonymous Try removing the dynamic content, instead enter a custom expression with the following value:

outputs('TotalOver8')?['body']

2020-04-06_1434.png 

View solution in original post

6 REPLIES 6
SamPo
Power Participant
Power Participant

@Anonymous When using the format number activity, you should be using the 'outputs' command to get the number. See the example below: 
2020-04-06_1351.png

Anonymous
Not applicable

@SamPo This is what im doing: 

 

totalover8.PNG

 

SamPo
Power Participant
Power Participant

@Anonymous What is the code you see when you hover over the item? Have you tried removing it and re-selecting it from the dynamic content window?

Anonymous
Not applicable

@SamPo 

 

I've already tried removing & adding dynamic content this is the code:

 

totalover8.PNG

SamPo
Power Participant
Power Participant

@Anonymous Try removing the dynamic content, instead enter a custom expression with the following value:

outputs('TotalOver8')?['body']

2020-04-06_1434.png 

Anonymous
Not applicable

That did the job! Thanks!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (4,571)