Get files (properties only) by Name

(0) Share

Report

Posted on by IPC_ahaas

1,401 Moderator

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":

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:

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

tom_riha 10,187 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
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')

1 people found this reply helpful.

Was this reply helpful? Yes No
IPC_ahaas 1,401 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No