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')
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.'.
Hey all,
Thanks! finally the run succeeded with this trigger:
@equals(triggerBody()?['price_hub_count'],triggerBody()?['source_count'])
with split on.
cheers!
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.
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
I think that instead of "item" you should be using something like "triggerOutputs()"
@equals(triggerOutputs()?['status'], 'ALL PRICES FROM SOURCE ARE AVAILABLE')
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.
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.