cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
txiong
New Member

Sharepoint List

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

1 ACCEPTED SOLUTION

Accepted Solutions
v-duann-msft
Community Support
Community Support

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-ar...

https://techcommunity.microsoft.com/t5/sharepoint/powershell-script-to-get-the-list-of-all-the-share...

https://sharepoint.stackexchange.com/questions/253471/how-to-get-lists-of-all-subsites-and-sites-in-...

https://sharepoint.stackexchange.com/questions/230187/retrieve-all-sites-and-all-subsites-from-the-s...

 

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

View solution in original post

4 REPLIES 4
v-duann-msft
Community Support
Community Support

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-ar...

https://techcommunity.microsoft.com/t5/sharepoint/powershell-script-to-get-the-list-of-all-the-share...

https://sharepoint.stackexchange.com/questions/253471/how-to-get-lists-of-all-subsites-and-sites-in-...

https://sharepoint.stackexchange.com/questions/230187/retrieve-all-sites-and-all-subsites-from-the-s...

 

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

View solution in original post

txiong
New Member

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??

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.

v-duann-msft_0-1620105520459.png

 

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

txiong
New Member

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

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,302)