Answered

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:

Using flows

I have the same question (0)

All responses (10)

Answers (1)

Sort by

Pstork1 69,254 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
HelloThereAll 82 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

HelloThereAll 82 on at

Like (8)

Report
Copy link

Link copied!
I managed to figure one out:
Modified le '@{utcNow()}'

Was this reply helpful? Yes No
vinylmatt 8 on at

Like (0)

Report
Copy link

Link copied!

Nice and simple, thx

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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>

Was this reply helpful? Yes No
Pstork1 69,254 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
mialtamo Microsoft Employee on at

Like (17)

Report
Copy link

Link copied!

To get rid of the warning simply add a /

Was this reply helpful? Yes No
Rich_P 6 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Hung_Pham 11 on at

Like (0)

Report
Copy link

Link copied!

Work like a charm!!! Thank you.

Was this reply helpful? Yes No
TomObright 4 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No