occasionally InvalidTemplate Error using get element in do until

(0) Share

Report

Posted on by Kattschka

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:

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

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Kattschka,

It is possible that you input the status#Id into the left side of the condition:

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

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.

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.

Was this reply helpful? Yes No
Kattschka 6 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No