web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate Document Library Repor...

Power Automate

Unanswered

Document Library Reporting Flow

(0) Share

Report

Report

Posted on by Community Power Pla...

Hello,

I am trying to setup a flow that will send a weekly report of he document library on SharePoint online.

The document library has a bunch of root folders. I would like the flow to filter the folders and grab all the files in the folders.

This is my current flow setup but I am not sure how to take advantage of the filter query to grab all the pdf's

Categories:

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

DeepakS 2,301 Most Valuable Professional on at

Like (0)

Report

Re: Document Library Reporting Flow

Hi @Anonymous ,

To exclude the Folders from files you can use following conditions:

Because IsFolder is an output property so you cant use it in Filter query.

Regards,

Deepak S

Was this reply helpful? Yes No
Expiscornovus 33,175 Most Valuable Professional on at

Like (0)

Report
Re: Document Library Reporting Flow

Hi @Anonymous,

In addition to @DeepakS his solution you can also try adding a filter query in the Get files (properties only) action to filter out the pdf files.

File_x0020_Type eq 'pdf'

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Document Library Reporting Flow

That is exactly what I was looking for thank you!

I have one more question. Is it possible to add a column in the table with a excel function to get the time difference from date create to date modified?

Was this reply helpful? Yes No

Join the conversation