Sharepoint List

(0) Share

Report

Posted on by txiong

Is there a way to get all list from all the sites into one customer list?

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-duann-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @txiong,

Thank you for posting.

According to your description, you would like to use flow to get all lists from all sites and save data into a customer list. If any misunderstanding, please kindly let me know.

I’m afraid it’s not feasible using flow. All SharePoint related actions only allow us input a static site address instead of a dynamic one. This is by design behavior and seems no way to overcome it so far.

However, we can try powershell script to get all lists of all sites. But there is nothing to do with flow. It’s internal feature using sharepoint powershell.
https://sharepoint.stackexchange.com/questions/273154/how-can-i-have-a-list-of-all-the-sites-that-are-part-of-the-same-hub
https://techcommunity.microsoft.com/t5/sharepoint/powershell-script-to-get-the-list-of-all-the-sharepoint-site/m-p/137157
https://sharepoint.stackexchange.com/questions/253471/how-to-get-lists-of-all-subsites-and-sites-in-powershell-csom-for-sharepoint-201
https://sharepoint.stackexchange.com/questions/230187/retrieve-all-sites-and-all-subsites-from-the-sharepoint-rest-api

To save exported results to a customer list, I believe we can only use CSV import at current stage.

You can also go to UserVoice to raise your idea. Maybe this feature will be available in the near future.
https://powerusers.microsoft.com/t5/Power-Automate-Ideas/idb-p/MPAIdeas

Hope the content above may help you.

Best regards,
Anna

Was this reply helpful? Yes No
txiong 6 on at

Like (0)

Report
Copy link

Link copied!

Is it possible to take all the list items and place it in an Variable array, then use the variables to set it in a custom list with only the specific columns??

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

Like (0)

Report
Copy link

Link copied!

Hi @txiong

Thank you for update.

It's still impossible using variable. Because we can't find all lists using one action. Even though we can put list details in variable, we still need to use 'get items' for each list as we can't input dynamic value in site address and list name.

Thus, we can't achieve it using flow. That's why I try to find other methods as workaround for you.

Sorry for the inconvenience may caused. Hope its clear to you.

Thanks
Anna

Was this reply helpful? Yes No
txiong 6 on at

Like (0)

Report
Copy link

Link copied!

Thank you very much, i'll accept your answer above as the solution and also put in a user enhancement request as well.

Thanks and Best regards,

Twinstar

Was this reply helpful? Yes No