Let's POWER Automate

From no-code to low-code

Menu
  • Expressions
  • Filters
  • General
  • Application specific solutions
    • Dataverse
    • Excel
    • Forms
    • Planner
    • Outlook
    • SharePoint
    • Teams
  • Triggers
  • Resources
  • ABOUT ME
  • Get help with your flow
Menu

Category: Filters

Power Automate to filter files in SharePoint by file name

Posted on February 14, 2021April 14, 2021 by Tom

“I’m trying to filter files in SharePoint by the file name but Power Automate tells me that column ‘Name’ doesn’t exist.”

Read more

How to get back dynamic content after ‘Filter array’ in Power Automate

Posted on January 17, 2021April 14, 2021 by Tom

“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.”

Read more

Power Automate filter on SharePoint Lookup column

Posted on January 10, 2021November 30, 2021 by Tom

“I need to get all SharePoint items with the same value in a lookup column, but the OData filter in Power Automate doesn’t return any items.”

Read more

How to use string with apostrophe (‘) in Power Automate filter query

Posted on December 23, 2020April 14, 2021 by Tom

“The Title field contains values like: “Tom’s column” (with apostrophe) and I need to use the Title in the Power Automate OData Filter Query.”

Read more

Power Automate filter on Multiple lines of text SharePoint column

Posted on December 16, 2020January 6, 2022 by Tom

“Since I changed the column to “Multiple lines of text”, I can no longer use “substring” to filter on that column in Power Automate.”

Read more

Order files returned by the ‘Get files’ action in Power Automate

Posted on November 4, 2020April 14, 2021 by Tom

“I want to order the output of the Power Automate ‘Get files’ action to build an HTML table. Order by the Sub Folder Name that houses the file, ascending order.”

Read more

Power Automate filter based on Person or Group column

Posted on October 18, 2020April 14, 2021 by Tom

Does your Power Automate flow need to filter only items or documents assigned to a specific user and ignore the rest?

Read more

4 most common problems with Filter Query in Power Automate

Posted on September 13, 2020August 23, 2022 by Tom

“My Filter Query in Power Automate action Get files doesn’t filter any data. It returns all documents all the time.”

Read more

Power Automate filter on SharePoint calculated column

Posted on September 9, 2020April 14, 2021 by Tom

“I need to use calculated column in a filter but Power Automate always returns Action ‘Get_items’ failed. Field ‘…’ of type ‘Calculated’ cannot be used.”

Read more

Why you should use filter instead of condition in Power Automate

Posted on September 6, 2020January 6, 2022 by Tom

Does your Power Automate flow use condition to process all the items instead of a filter to get only the relevant ones?

Read more
  • Previous
  • 1
  • 2
  • 3
  • Next

Do you know what to do, but not how to do it?

Get The Ultimate Power Automate expressions cheat sheet and translate your thoughts into flows with ease!


There's also the HTTP requests to SharePoint cheat sheet to help you overcome limitations of some standard actions!

Do you struggle with the various expressions, conditions, filters, or HTTP requests available in Power Automate?

I send one email per week with a summary of the new solutions, designed to help even non IT people to automate some of their repetitive tasks.

All subscribers have also access to resources like a SharePoint Filter Query cheat sheet or Date expressions cheat sheet.

Zero spam, unsubscribe anytime.

  • How to find Excel rows missing in SharePoint list (Power Automate)March 29, 2023
  • Check whether user exists in AAD with Power AutomateMarch 26, 2023
  • How to highlight whole SharePoint row based on calculated dateMarch 22, 2023
  • Why is your Power Automate flow running so slow?March 19, 2023
  • How to add multiple links to the Power Automate approval taskMarch 15, 2023

Power Automate blogs worth visiting

Damien Bird
Dennis (Expiscornovus)
Paul Murana

©2023 Let's POWER Automate | Theme by SuperbThemes