I have two libraries Project X and Project Y, each of the libraries holds many project folders.

I want to know if it is possible to show up the list of the projects folder names of both libraries in a SharePoint list view.

So the query should pull data from both libraries and return the result needed in a View.

I thoughts about three different solutions but I still need to choose or find the best:

  1. A power automate that triggers daily to get the list of the project folders and some metadata and update a SharePoint list with those data (But the flow might take some time since I have more than 100k projects folders stored in total for both libraries).
  2. A power Bi report that can show up those data from those two libraries.
  3. A SharePoint page with two different Document library web parts arranged (not the best).

Is there any other way to achieve the above? If so, what do you think is the best option to proceed with?

Note: that both libraries are updated on a daily basis so the view should be always updated in case we need to filter.

Any help is highly appreciated. Thank you in advance.

1 Answer 1


As another way, we can use the Highlighted content web part in modern page, fill in the custom query to display folders in these two libraries:

enter image description here

Note, per my test the folder icon will not show, like this:

enter image description here

  • Hello @Julie_MSFT, Thank you for providing the above example. I have tried out the steps mentioned and it works, however in the list view I am not able to filter by a certain Project Name so if I have a lot of projects how will I be able to find them? Looking forward to your response.
    – SmithBZ
    Sep 10, 2021 at 10:31
  • In addition to the above can we display for example file size column?
    – SmithBZ
    Sep 11, 2021 at 8:01
  • Unfortunately,this way will not able to filter.
    – Julie_MSFT
    Sep 13, 2021 at 6:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.