web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : rrQna1vZS3PYT1HMombOQ8
Power Automate - Building Flows
Answered

Get files (properties only) by Name

Like (0) ShareShare
ReportReport
Posted on 30 Sep 2022 14:24:31 by 1,278 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":

 

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

 

 

 

  • IPC_ahaas Profile Picture
    1,278 Moderator on 30 Sep 2022 at 20:58:48
    Re: Get files (properties only) by Name

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

  • Verified answer
    tom_riha Profile Picture
    10,127 Most Valuable Professional on 30 Sep 2022 at 20:35:01
    Re: Get files (properties only) by Name

    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')

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2