Removing the warning "Updating action 'Get items' to use OData filter queries can improve the performance of your flow..."

(0) Share

Report

Posted on by HelloThereAll

Whenever I save my flow, I get the warning "Updating action 'Get items' to use OData filter queries can improve the performance of your flow...". The warning goes on, but I think you get the idea. The thing is that I want to get ALL the items, and don't want Flow to keep flagging it as a problem. How do I get this false flag to not appear anymore?

Categories:

Business Process Flows

All responses (10)

Answers (1)

TomObright 4 on at

Like (1)

Report

Re: Removing the warning "Updating action 'Get items' to use OData filter queries can improve the performance of your flow..."

So now we have to put "empty code" into our flow in order to turn off bogus warnings. I would love to use an OData filter query in my flow... but the filter does not work to filter out empty records, or allow expressions like length to see if a record value is empty, so I am stuck filtering arrays afterwards. Sometimes Microsoft even outdoes itself for weirdness.
Hung_Pham 11 on at

Like (0)

Report

Re: Removing the warning "Updating action 'Get items' to use OData filter queries can improve the performance of your flow..."

Work like a charm!!! Thank you.
Rich_P 6 on at

Like (0)

Report

Re: Removing the warning "Updating action 'Get items' to use OData filter queries can improve the performance of your flow..."

Sorry, don't understand. What was modified and where was it modified? I don't see how to apply this to get rid of the warning message when I use the SharePoint get items action. Thanks
mialtamo Microsoft Employee on at

Like (17)

Report

Re: Removing the warning "Updating action 'Get items' to use OData filter queries can improve the performance of your flow..."

To get rid of the warning simply add a /
Pstork1 65,906 Most Valuable Professional on at

Like (0)

Report

Re: Removing the warning "Updating action 'Get items' to use OData filter queries can improve the performance of your flow..."

He put it in the Odata filter for the get items action. It doesn't fix any problem, but it does suppress the warning message. It should also be mentioned this is a Warning message, not an error. The flow will not fail just because this message appears.
Community Power Pla... on at

Like (0)

Report

Re: Removing the warning "Updating action 'Get items' to use OData filter queries can improve the performance of your flow..."

Hi, can i know how do you solve this problem? Where do u apply this utcNow? i keep getting this message as well where the flow failed:
Updating action 'Get items' to use OData filter queries can improve the performance of your flow. Learn more: <https://flow.microsoft.com/blog/advanced-flow-of-the-week-filtering-with-odata>
vinylmatt 8 on at

Like (0)

Report

Re: Removing the warning "Updating action 'Get items' to use OData filter queries can improve the performance of your flow..."

Nice and simple, thx
Verified answer

HelloThereAll 82 on at

Like (8)

Report
Re: Removing the warning "Updating action 'Get items' to use OData filter queries can improve the performance of your flow..."

I managed to figure one out:
Modified le '@{utcNow()}'
HelloThereAll 82 on at

Like (0)

Report

Re: Removing the warning "Updating action 'Get items' to use OData filter queries can improve the performance of your flow..."

I was hoping for at least a universally applicable filter that wouldn't filter anything out. I tried looking some up, but they didn't work in my Flow, and I didn't want to spend a lot of time figuring out a filter I wasn't interested in using.
Pstork1 65,906 Most Valuable Professional on at

Like (0)

Report

Re: Removing the warning "Updating action 'Get items' to use OData filter queries can improve the performance of your flow..."

To the best of my knowledge you can't turn the warning off. All you can do is click on the X to close it and continue with saving the flow.