Skip to main content

Notifications

Power Automate - General Discussion
Answered

conditional trigger

(1) ShareShare
ReportReport
Posted on by 13

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).pngScreenshot (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.'.

 

 

 

 

  • adarsha_chaubey Profile Picture
    adarsha_chaubey 13 on at
    Re: conditional trigger

    Hey all,

    Thanks! finally the run succeeded with this trigger:

    @equals(triggerBody()?['price_hub_count'],triggerBody()?['source_count'])

    with split on.

    cheers!

  • Verified answer
    ashyriverflow Profile Picture
    ashyriverflow 128 on at
    Re: conditional trigger

    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.

    ashyriverflow_0-1652925650796.png

    + Get the raw outputs of the trigger

    ashyriverflow_1-1652925707603.png

    + From there you can see the actual key/value pair of the "status" returned from Power Bi.

    + Then compose the trigger condition accordingly.

     

  • adarsha_chaubey Profile Picture
    adarsha_chaubey 13 on at
    Re: conditional trigger

    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

  • mgrachii Profile Picture
    mgrachii 206 on at
    Re: conditional trigger

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

     

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

  • adarsha_chaubey Profile Picture
    adarsha_chaubey 13 on at
    Re: conditional trigger

    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.Screenshot (23).pngScreenshot (24).png

  • ashyriverflow Profile Picture
    ashyriverflow 128 on at
    Re: conditional trigger

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard