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

Please help! Invalid template - cannot be evaluated - property selection not supported on values of type 'string'.

i don't understand why all of a sudden i am receiving this error. The form did not change and the flow did not either.

 

As you can see I'm getting an error message during the send approval step.

 

The 'Format_number_hrly_rate' it's complaining about passes in that step successfully.

 

I converted the string to number and then formatted it.

 

Why am I receiving this error on all of my approval steps?

 

I even disconnect and reconnected the 'Approval' connection and that did not work.

 

Please help! 🙂

 

InvalidTemplate_Property selection is not supported on values of type string.PNG

 

Here is the flow text where I convert string to number (float) and then format...

 

format_hrly_rate.PNG

format_hrly_rate compose.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
efialttes
Super User III
Super User III

Hi!

By reading your error message, it seems inside your Approval' action block there is an expression like this one

 

body('Format_number_Hrly_Rate')?['body']

 

 

My suggestion is to replace it and use the following one instead:

 

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

 

I've tested on my side, its the way 'Format number' outputs sintaxis looks now.

Since the first expression was working fine till now, I assume Power Automate engineers have opted to use new sintax for this action block output, and rolled out the swap recently ☹️

Flow_Format_Number.png

 

 

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!



View solution in original post

4 REPLIES 4
pennyland
Advocate II
Advocate II

It appears that this is due to the converting of a string to number (float integer) is failing. The fact that it's in the approval step i believe is irrelevant.

 

This used to work (2-3 weeks or so ago). Did something behind the scenes change for conversion of string to float integer? 

 

efialttes
Super User III
Super User III

Hi!

By reading your error message, it seems inside your Approval' action block there is an expression like this one

 

body('Format_number_Hrly_Rate')?['body']

 

 

My suggestion is to replace it and use the following one instead:

 

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

 

I've tested on my side, its the way 'Format number' outputs sintaxis looks now.

Since the first expression was working fine till now, I assume Power Automate engineers have opted to use new sintax for this action block output, and rolled out the swap recently ☹️

Flow_Format_Number.png

 

 

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!



View solution in original post

pennyland
Advocate II
Advocate II

Thank you. That was exactly the problem. I changed it and it worked fine.

However, when the flow errors out for any other reason, it automatically is putting the incorrect syntax/format back into the flow!

 

I've had to redo this correction over and over.  It sticks as long as nothing else fails.

 

It's been rather frustrating since i have several of these approval blocks using the 'formatted' value.

 

I sincerely appreciate the quick reply above and noting exactly what was going on. Thank you!

 

Weird.... sounds as if something's really wrong with the last rollout.

 

Open a ticket can take some time, so I am just guessing you can get rid of the action block and use an expression based on this equivalent function instead

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#f...

 

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
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

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.

Users online (1,337)