Answered

odata filter - scheduled workflow

(0) Share

Report

Posted on by DCNehs

407

I have set the ODATA filter as IssueStatus eq 'DTC to Verify' which works fine to send them a list of all of issues that need to be reviewed.

The problem I'm running into is that even when there aren't any issues set with the status of DTC to Verify, it's still sending an email but an empty list which is a bit goofy. I only want an email to be sent if there are issues.

Is there a way to get it to NOT run if there aren't any under that status? I tried adding the Trigger below, but when trying to test (using manual) it errors and comes up with Cannot read property 'properties' of undefined. Or Maybe this is ok and it's supposed to do that?

@equals(triggerBody()?['IssueStatus']?['Value'],'DTC to Verify')

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

tom_riha 10,185 Most Valuable Professional on at

Like (1)

Report

Re: odata filter - scheduled workflow

Hello @DCNehs ,

scheduled flows are not connected to any item/file, therefore, you can't use any list/library property in the trigger condition. But you can check if the 'Get items' found any items that fit the filter, and send the email only if it did.

Add a 'Condition' after the 'Get items' that will check if the length(...) of the 'value' output is greater than 0 (an item was found). If it's greater, process the data and send an email. If it's not, do nothing.

Was this reply helpful? Yes No
DCNehs 407 on at

Like (0)

Report

Re: odata filter - scheduled workflow

Ahhh, that would make sense with the trigger. This did the trick very neat for someone still learning. Probably not so much for you 🙂

Thanks so much! This will definitely come in handy and now i have a bit better understanding about length.

Was this reply helpful? Yes No