Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Get a specific PDF from a folder in SharePoint

(0) ShareShare
ReportReport
Posted on by

Hello, I have a folder containing reports that go through many iterations before being finalized, and my goal is to find the finalized one and stamp a watermark on it. Each series of reports has its own DocID and a Status column used to identify them. I need to create a Flow that activates when an item is created containing the DocID. 

 

When the item containing the DocID is created in a SharePoint list, I need to get that specific file/PDF based on the retrieved DocID and the Status eq Approved. Any help would be greatly appreciated. 

  • v-jefferni Profile Picture
    on at
    Re: Get a specific PDF from a folder in SharePoint

    Hi @CSilva ,

     

    You need a Condition control first and check if the output of Get files is empty. If not, get the first file using first in the expression:

    vjefferni_0-1719799695153.png

     

    If there won't be more than 1 file in the output, actually the Apply to each will help you create the flow and won't affect the performance, it's not something to worry about.

     

    Best regards,

  • CSilva Profile Picture
    on at
    Re: Get a specific PDF from a folder in SharePoint

    Thank you for the response. I have done that, but my issue is that when doing subsequent steps, it forces me to do an 'Apply To Each' since we use the 'Get Files' action. Is there a way to locate and grab a single file that I can edit in subsequent steps?

  • v-jefferni Profile Picture
    on at
    Re: Get a specific PDF from a folder in SharePoint

    Hi @CSilva ,

     

    Have you tried filter query in Get files action?

    vjefferni_0-1719563254493.png

     

    Best regards,

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >