“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.”
Category: Filters
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 and the tasks closed today.”
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.”
Power Automate to filter files in SharePoint by file name
“I’m trying to filter files in SharePoint by the file name but Power Automate tells me that column ‘Name’ doesn’t exist.”
How to get back dynamic content after ‘Filter array’ in Power Automate
“I don’t see the dynamic content output from the Power Automate ‘Filter array’ action, all I see are the values from the action before the filter was applied.”