Get all file names from a SharePoint Document Library?

(0) Share

Report

Posted on by Australia

387

Hi fellow Power Automate veterans,

Is there a way I can use Power Automate to extract all file names from a SharePoint Document Library?

Perhaps like list in cmd where it keeps the folder path that'd be even better.

My current library structure is as follows:

My Document Library (500+ files in total)

ABC123.xls

ABC224.xls

ABC302.xls

...
>SubFolder 2021

2021_1.xls

2021_2.xls

...

>SubFolder 2020

2020_1.xls

2020_2.xls

...

Many thanks.

Categories:

Building flows

I have the same question (0)

All responses (10)

Answers (1)

Sort by

Expiscornovus 33,830 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @Australia,

You could use a Send an HTTP request action for this and use the REST API to retrieve the items. You can apply a select to retrieve the FileLeafRef (file name).

Below is an example of that approach

_api/web/lists/getbytitle('Documents')/items?$select=FileLeafRef

Was this reply helpful? Yes No
Australia 387 on at

Like (0)

Report
Copy link

Link copied!

@Expiscornovus many thanks for the prompt reply!
I am just wondering if this API is free?
How do I save the results as a CSV/Excel file?
Possible to retain the folder name/path if possible?

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

Like (0)

Report
Copy link

Link copied!
Hi @Australia,

This is an action from the SharePoint connector (a non-premium one). The REST API is part of the SharePoint Online product, https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/complete-basic-operations-using-sharepoint-rest-endpoints.

So, no additional licensing should be needed to use both.

For a CSV you can use the Create CSV table action. Use the body/value output in the From field. You can use this expression for that:

outputs('Send_an_HTTP_request_to_SharePoint')?['body/value']

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,830 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
Hi @Australia,

Apologies, forgot to respond to your Path question.

Amend the uri to this please (added the FileRef field in the select) to also include the path:

_api/web/lists/getbytitle('Documents')/items?$select=FileLeafRef,FileRef

Was this reply helpful? Yes No
Australia 387 on at

Like (0)

Report
Copy link

Link copied!

@Expiscornovus It works, marvellous! Thank you so much. Your solution helped me tremendously.
Now I need to use Power Automate Desktop to upload these files to a website. Would you be the one to ask, too? IF yes, I can open a new post. 🙂

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

Like (0)

Report
Copy link

Link copied!

Hi @Australia,

Great to hear that it works 🙂

I could help out with desktop flows. However, there are also a lot of other people who can help you too 😁

Just post a new thread in this section:

https://powerusers.microsoft.com/t5/Power-Automate-Desktop/bd-p/MPADesktop

Was this reply helpful? Yes No
Australia 387 on at

Like (0)

Report
Copy link

Link copied!

Thanks @Expiscornovus . I've just posted here: Upload files to a website in a loop? - Power Platform Community (microsoft.com) 😄

Was this reply helpful? Yes No
SallyTan1 2 on at

Like (0)

Report
Copy link

Link copied!

Hi, are there any ways I can extract the file name so that I can have it on my list?

Was this reply helpful? Yes No
CU23070452-1 on at

Like (0)

Report
Copy link

Link copied!

@SallyTan1 wrote:
Hi, are there any ways I can extract the file name so that I can have it on my list?

Add dynamic content -> under a suitable action that returns file properties, like "Get files (properties only)" (don't know what you have there before) click "File name with extension". If no extension needed, then "Name".

Was this reply helpful? Yes No
Abyshek 2 on at

Like (0)

Report
Copy link

Link copied!

Sorry for digging up this old thread. But, thanks a lot for providing the solution for extracting the file names from a Document Library. I now want to add those file names in a List as new items. Can you please guide me how to do it? I have tried the following but with no luck.

Was this reply helpful? Yes No