PowerApp with List referencing related content in a Library

[stocktho]

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?

[stocktho]

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?

[stocktho]

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?

[v-yamao-msft · Accepted solution]

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

[stocktho]

Thanks this worked perfectly!

[astrokade]

@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