I am all of a sudden having the error below come up on a workflow yesterday. It was working fine for the last 2 weeks and even Wednesday but yesterday it failed. I used my test list to enter the same information and the workflow ran with no issues and then I've checked everything and don't see anything that doesn't match. Any ideas? How is it working in the other list and not this one all of a sudden?
'Initialize_string_variable_Body_of_Submitted_Email' inputs at line '1' and column '44722': 'The template language expression 'body('Format_number_COSellCalcColumn')?['body']' cannot be evaluated because property 'body' cannot be selected. Property selection is not supported on values of type 'String'
I used HTML in the initialize variable area (string) and have a calculated column where i used for format tool
Solved! Go to Solution.
@ekarim2020 , the issue isn't in an email, it's in the initialize variable area. I then add the variable with the HTML in the body of the email so if i have to make any changes, i only need to do it in 1 place. What I ended up having to do is leave the initialize variable blank and then add Set variable and it worked.
The interesting thing is that it worked yesterday morning, but not in the afternoon. I have other workflows set up the same way in this tool and had no issues with them functioning. Not even in my test form. Not sure what happened here and why it decided to not like it in the PM.
Can you delete and then re-add the dynamic content for the formatted number.
When you hover over the dynamic content, it should look like the text below:
Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.
@ekarim2020 , the issue isn't in an email, it's in the initialize variable area. I then add the variable with the HTML in the body of the email so if i have to make any changes, i only need to do it in 1 place. What I ended up having to do is leave the initialize variable blank and then add Set variable and it worked.
The interesting thing is that it worked yesterday morning, but not in the afternoon. I have other workflows set up the same way in this tool and had no issues with them functioning. Not even in my test form. Not sure what happened here and why it decided to not like it in the PM.
I agree that this is very odd that the flow has stopped working suddenly. I'm not able to reproduce the error using the dynamic content for Formatted Number:
Note the difference between the expressions used in your initialize variable and my test - which is not correct:
The only way I can reproduce the exact same error message is to use the same expression as I see in your initialize variable :
This then produces the same error message - which means that the expression is not valid:
Some options are:
Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
68 | |
24 | |
18 | |
16 | |
13 |
User | Count |
---|---|
135 | |
44 | |
32 | |
32 | |
29 |