cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

occasionally InvalidTemplate Error using get element in do until

Hi everybody,

 

As I am working on a german system screenshots will display german, but I will translate as good as I can.

 

I have a flow which has to be "activated" by setting an specific field, which is a dropdown, to a value different from it's inital value. Therefore I trigger with an "If Item is created", then I have a do until loop set to check for the field value with "Get Item" inside the loop:

Flow.PNG

The code of do until is @equals(body('Element_abrufen')?['Status']?['Value'], 'Anforderung Abgesendet')

 

It translates as unable to process template language expression in Aktion "Warten_auf_Absendung_durch_Ersteller" in line "1" and column "2033" : the template "equals(body('Element_abrufen')?['Status']?['Value'], 'Anforderung Abgesendet')" can't be evaluated because the property "Value" cannot be chosen. A selection of properties is not supported for "Integer" values. For further information...

 

So I don't know what to get from that error. If I am correct it tells me, my dropdown "status" (which contains just two string-entries and is displayed to users as "Anforderungsstatus" as seen in the first picture) suddenly is adressed as an int? I don't see how that is even possible, and oddly it works just fine on many other tries.

 

If anyone has an idea how to solve this I would really appreciate it.

If there are any questions or problems with my translation please don't hesitate to ask.

 

Thanks,

Kattschka

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: occasionally InvalidTemplate Error using get element in do until

Hi @Kattschka,

 

It is possible that you input the status#Id into the left side of the condition:
Annotation 2019-11-14 105658.png

 I have reproduced the SharePoint list and the Flow, and it works well:

Annotation 2019-11-14 110254.png

 Annotation 2019-11-14 110345.png

One point needs to notice is that the Do Until only runs 60 times in default, you can tweak the limits to make it run longer so that it could monitor the change of the column before run out.

Annotation 2019-11-14 110948.png

 

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

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: occasionally InvalidTemplate Error using get element in do until

Hi @Kattschka,

 

It is possible that you input the status#Id into the left side of the condition:
Annotation 2019-11-14 105658.png

 I have reproduced the SharePoint list and the Flow, and it works well:

Annotation 2019-11-14 110254.png

 Annotation 2019-11-14 110345.png

One point needs to notice is that the Do Until only runs 60 times in default, you can tweak the limits to make it run longer so that it could monitor the change of the column before run out.

Annotation 2019-11-14 110948.png

 

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

Highlighted
Regular Visitor

Re: occasionally InvalidTemplate Error using get element in do until

Hi @v-litu-msft,

 

I did not know about the option to adress fields in that way, but I hve changed my Do until to @equals(body('Element_abrufen')?['Status#ID'], 1) and it seems to be working fine and just the way it did before.

I guess that is what happens in the background anyway, so maybe that is how the, to me, senseless error is explained. I will grant my users some time to create more content in the list and check wether the error still occurs. If not I will come back next week and mark your answer as solution, else I will ask again anyway 😉

 

For the limits: I had already erased the count value and set the Tiemout to 30Days, including sending an message to the creator of the affected item telling him to try again. Nevertheless thanks for thinking so far and mentioning this probably often forgotten changes.

 

Best regards,

Kattschka

Helpful resources

Announcements
FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (6,528)