Unanswered

Get a specific PDF from a folder in SharePoint

(0) Share

Report

Posted on by CSilva

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.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @CSilva ,

Have you tried filter query in Get files action?

Best regards,

Was this reply helpful? Yes No
CSilva on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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:

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,

Was this reply helpful? Yes No