cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
IPC_ahaas
Responsive Resident
Responsive Resident

Get files (properties only) by Name

I have a list of files in a Library that either start with:

  • Employee Termination Request
  • Employee Termination
  • Supervisor Comments

 

I have a sperate flow that combines "Employee Termination Request" and "Supervisor Comments" into "Employee Termination", so I want to only find files that start with "Employee Termination Request":

 

IPC_ahaas_0-1664547674893.png

This is the "Name" field is actually "Title" which returns as "{Name}" using Get files (properties only).

I trued using "Title", "Name", and "{Name}" in the Filter Query and I get no results with all of them:

IPC_ahaas_1-1664547832919.png

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
tom_riha
Super User
Super User

Hello @IPC_ahaas ,

the file name is represented by a hidden column FileLeafRef, and if you want to search if a file name starts with a string you can't use 'equals' operator. Use startsWith(...) instead.

startswith(FileLeafRef, 'Employee Termination Request')


[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]

View solution in original post

2 REPLIES 2
tom_riha
Super User
Super User

Hello @IPC_ahaas ,

the file name is represented by a hidden column FileLeafRef, and if you want to search if a file name starts with a string you can't use 'equals' operator. Use startsWith(...) instead.

startswith(FileLeafRef, 'Employee Termination Request')


[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]

Hot **bleep**, that worked. Thank you @tom_riha 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (2,730)