cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
UK_Power
Level: Power Up

Display data from multiple document libraries

Hi Everyone, I've got a requirement to display all Document items with their respective data such as FileName, Created By, Custom Column1 and Custom Column2. Scenario: I have an SPO Site with 5 different Document Libraries and would like to display all items with metadata in a single view using PowerApps. Any ideas would be great to achieve this requirement. Thanks

1 REPLY 1
Microsoft v-siky-msft
Microsoft

Re: Display data from multiple document libraries

@UK_Power 

To merge two libraries into one view, please ensure all column names you want to show are the same.

Please try the following codes, take FileName as an example. You can add more column in ShowColumns function. Reference: ShowColumns 

Ungroup([ShowColumns('SP library1',"{FilenameWithExtension}"),ShowColumns('SP library2',"{FilenameWithExtension}")],"Value")

Snipaste_2020-01-20_10-55-11.png

Sik

 

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors
Users online (5,033)