Filtering Microsoft Power Automate “Get Items” with Filter Query

Learn how to use the get items with Microsoft Power Automates, formerly Flow, filter query.

PPM Works offers a full range of Project and Portfolio Management consulting services, all designed to help your company reach its potential. We are a Microsoft Gold Partner, specializing in Microsoft Project and Microsoft 365. Whether you’re looking for a small tweak or complete overhaul, we have you covered. Our services are available a la carte so you get precisely what you need.

[lairdbishop]

Thanks! This is concise and to the point. I wasted a lot of time before I found this. You addressed exactly what I wanted to know without all the chaff. Subscribing.

[themaraudingmoose]

This was great! Thank you for the walkthrough and monthzebra!

[blackburd]

Thank you very much very easy to follow.

[olenaoleary]

Only one thing to note: why in your example you choose name for variable MONTH? when offering for user to choose type of exp? It is confusing

[ShirubyoSan]

Wow thxs a lot! Saved my life, indeed! :)

[Fluxtroid]

Thank you so much. I specifically needed to know how to find the column name to use (without having to awkwardly experiment etc) and you nailed it for me. Thank you.

[friendlyfriesen]

My SharePoint columns are normally the name without a space in them, not sure if that is a change in the last while, but if I have issues I will check to see if it is the _x0020_ etc... problem.

[siddaramsangolagi]

What needs to be done if the filter value has special character like () or ‘ in it

[JonathanSARTORI]

Hello, Thank you for this very useful video, my question is: what is the filter query looking if my column is a lookup type column? Thank you for your help

[rf]

There are still limitations on some areas. Like Filter Query cannot be done on Calculated columns.

[edgarabud]

Hi, Nice video, I got a list in sharepoint with more than 100K rows, when i use the "Get Item", ¿Does the query goes directly to the sharepoint list? or it make the query to the first 5K rows? do you know if this query is delegable to the sharepoint list?

[imaxi]

Do you know how can I filter using (Created eq Modified) ? I need to get only those items which were not modified since they have been created, but I keep receiving a query error.
By the way, great video!

[RodLefton]

I get an error, Saying That my column does Not exist, any ideas? Great Video and thx.