conditional trigger

(1) Share

Report

Posted on by adarsha_chaubey

Hey,

I am using this trigger for BI automation as trigger condition but the flow run is failing.

input:

@equals(item()?['status'], 'ALL PRICES FROM SOURCE ARE AVAILABLE') Screenshot (20).png Screenshot (21).png

error:

Unable to process template language expressions for trigger 'manual' at line '1' and column '9337': 'The template language function 'item' is not supported by schema version '<null>': the function is introduced starting with version '2015-08-01-preview'. Please see https://aka.ms/logicexpressions for more details.'.

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (1)

Sort by

ashyriverflow 128 on at

Like (0)

Report
Copy link

Link copied!

hi there, why are you using item()? Should it be triggerBody()...?
to verify trigger condition, i usually make a run without the trigger condition and see the output returned from the trigger. From it, you can get the right property name.

Was this reply helpful? Yes No
adarsha_chaubey 13 on at

Like (0)

Report
Copy link

Link copied!

Hi,
I need to create a trigger whenever the status column shows ("ALL PRICES FROM THE SOURCE ARE AVAILABLE" ). I am trying to create an appropriate syntax for the same but still the flow is having issues. Kindly let me know what trigger would work in this condition.

Was this reply helpful? Yes No
mgrachii 206 on at

Like (0)

Report
Copy link

Link copied!

I think that instead of "item" you should be using something like "triggerOutputs()"

@equals(triggerOutputs()?['status'], 'ALL PRICES FROM SOURCE ARE AVAILABLE')

Was this reply helpful? Yes No
adarsha_chaubey 13 on at

Like (0)

Report
Copy link

Link copied!

This is not working basically the split on default array for me is @triggerBody()['rows'] and I have tried many ways but no trigger condition is making the run successful

Was this reply helpful? Yes No
Verified answer

ashyriverflow 128 on at

Like (2)

Report
Copy link

Link copied!

if Split On is "On" then there will be a run per one item/row at a time. If Split On is disabled then all selected rows will be combined in one Flow run and it's not possible to filter an array with trigger condition.
To troubleshoot it further, I think you can go to flow page (flow.microsoft.com), edit and test the Flow directly from there.
+ First, remove all the trigger condition, enable "Split On"
+ Trigger the Flow from Power BI
+ Go to history of the Flow from Flow page and check the most recent run.
+ Get the raw outputs of the trigger
+ From there you can see the actual key/value pair of the "status" returned from Power Bi.
+ Then compose the trigger condition accordingly.

Was this reply helpful? Yes No
adarsha_chaubey 13 on at

Like (0)

Report
Copy link

Link copied!

Hey all,
Thanks! finally the run succeeded with this trigger:
@equals(triggerBody()?['price_hub_count'],triggerBody()?['source_count'])
with split on.
cheers!

Was this reply helpful? Yes No