cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

PowerApp with List referencing related content in a Library

I'm working on a PowerApp with list and the standard Browse, Detail and edit screens. Each line item in the list mulitple corresponding files in a library. I want to be able to review the files in the library that correspond to the list item. There is a list Item ID in the list and I've added metadata to the library with the same ID, thus we have a common key. How would I create a Library Detail page that could be navigated to from the Browse page to show only those files that correspond to a given line item?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: PowerApp with List referencing related content in a Library

Hi stocktho,

 

According to your description, I create an app on my side. Hope it could be a reference for you.


I have a document library named TestLibrary2, and there is a Number column named ListID that correspond to the ID of the list item.


Create connections to both the list and the library.


On the BrowseGallery screen, show all the items of the list.


Add a new screen1, then add a gallery on it and set its Items property as: Filter(TestLibrary2,ListID=BrowseGallery1.Selected.ID)


Then when navigate from the BrowseGallery screen to screen1, the expected files will be displayed.

 

About how to add connection to SharePoint library, please check this blog for a reference:
https://powerapps.microsoft.com/en-us/blog/leveraging-sharepoint-document-library-and-calendar-lists...


Please try it on your side. If you need more help, please feel free reply.


Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
Highlighted
Regular Visitor

PowerApp with List referencing related content in a Library

I'm working on a PowerApp with list and the standard Browse, Detail and edit screens. Each line item in the list mulitple corresponding files in a library. I want to be able to review the files in the library that correspond to the list item. There is a list Item ID in the list and I've added metadata to the library with the same ID, thus we have a common key. How would I create a Library Detail page that could be navigated to from the Browse page to show only those files that correspond to a given line item?

Highlighted
Regular Visitor

PowerApp with List referencing related content in a Library

I'm working on a PowerApp with list and the standard Browse, Detail and edit screens. Each line item in the list has mulitple corresponding files in a library. I want to be able to review the files in the library that correspond to the list item. There is a list "Item ID" in the list and I've added as metadata to the library with the same ID, thus we have a common key. How would I create a Library Detail page that could be navigated to, from the Browse page, to show only those files that correspond to a given line item?

Highlighted
Community Support
Community Support

Re: PowerApp with List referencing related content in a Library

Hi stocktho,

 

According to your description, I create an app on my side. Hope it could be a reference for you.


I have a document library named TestLibrary2, and there is a Number column named ListID that correspond to the ID of the list item.


Create connections to both the list and the library.


On the BrowseGallery screen, show all the items of the list.


Add a new screen1, then add a gallery on it and set its Items property as: Filter(TestLibrary2,ListID=BrowseGallery1.Selected.ID)


Then when navigate from the BrowseGallery screen to screen1, the expected files will be displayed.

 

About how to add connection to SharePoint library, please check this blog for a reference:
https://powerapps.microsoft.com/en-us/blog/leveraging-sharepoint-document-library-and-calendar-lists...


Please try it on your side. If you need more help, please feel free reply.


Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Regular Visitor

Re: PowerApp with List referencing related content in a Library

Thanks this worked perfectly!

Highlighted
New Member

Re: PowerApp with List referencing related content in a Library

@v-yamao-msft 

Hi,

 

Just hijacking this old post to see if you can help me get this right!

I have a similar requirement but need to display a list item based on a document library gallery selection. Both share a common field called DocumentGroupID I would like to match.

 

I tried variations of the following with no success so far:

 

Filter(DMScol, DocumentGroupID='Edit/ReleaseGallery'.Selected.DocumentGroupID)

 

Thanks

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,252)