cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
dprjustin
Level: Powered On

Find Files in Doc Library that Contain a String from a List

I have process writing site reports and publishing them to a document library with a filename in the format of "Report Name - Site Name". I also have a SharePoint list that contains the following fields

  • Site Name
  • Contact Emails

I'm trying to write a Flow that will find files that contain the Site Name in the filename, and then email them to the Contact Emails. There doesn't appear to be an ODATA filter that supports a 'contains' function. I tried to use the 'endsWith' expression, but am having issues with pushing a variable into it. What is the best way to find the file contents for files where the filename contains a variable string?

1 ACCEPTED SOLUTION

Accepted Solutions
dprjustin
Level: Powered On

Re: Find Files in Doc Library that Contain a String from a List

Solved this by skipping the ODATA filter and instead using a Condition

View solution in original post

2 REPLIES 2
dprjustin
Level: Powered On

Re: Find Files in Doc Library that Contain a String from a List

Solved this by skipping the ODATA filter and instead using a Condition

View solution in original post

Sandritto
Level: Powered On

Re: Find Files in Doc Library that Contain a String from a List

Hi!

 

I think I'm having the same issue. Could you explain how did you get it working? 

 

Sandritto

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,705)