“I’m trying to filter rows, but Power Automate keeps telling me that the column used in Filter Query doesn’t exist… why?”
Category: Filters
Use a ‘not contains’ operator in Power Automate Filter Query
“I know there’s an operator to return SP items that contain a string, but what about not contains, how to do such filter in Power Automate?”
Filter SharePoint items with date in the same month in Power Automate
“How to filter items with date on the same month/year as current date in Power Automate, e.g. Created date column value is 09/15/2021 or 09/01/2021 and current date is 09/29/2021.”
How to combine multiple filters in Get items Filter Query (Power Automate)
“I am able to use each filter independently, but when I try to use multiple filters at once in the Filter Query it doesn’t work, what’s the right syntax in Power Automate?”
How to get over 100 items limit with the ‘Get items’ in Power Automate
“‘Get Items’ returns only 100 entries from all the items it should return, how can I overcome this limit and get all the relevant items with Power Automate?”
Build a report with new, closed and open Planner tasks (Power Automate)
“Can I use Power Automate to produce a daily report of the Planner tasks? I’d like to see the new tasks, open tasks, etc.”
How to apply multiple conditions in the ‘Filter array’ Power Automate action
“I know I can use the ‘Filter array’ action in Power Automate to do this, but how do I set it up to use multiple conditions?”
How to order SharePoint items returned by ‘Get items’ in Power Automate
“Is it possible to use multiple fields in the ‘Order By’ Power Automate OData filter on a SharePoint ‘Get items’ action? i.e. sort by Title and Date field?”
Power Automate filter on SharePoint Date and Time column
“Is there any way to set an ODATA Filter Query to let Power Automate filter all SharePoint items where some date field is less or equal to today’s date?”
Power Automate reminder using date in SharePoint calculated column
“I need a reminder based on a calculated date from another date column, but Power Automate tells me I can’t use that SharePoint column.”