Unanswered

Filtering multiple SharePoint Lists on Display screen

(0) Share

Report

Posted on by sloth790

I am working on a solution with three SharePoint lists as Data Sources. I have a Projects List, a Locations List, and an Updates List.

I'm trying to make it so that the user can click on an entry in the Projects List and go to a details screen that shows additional columns from the Projects List, as well as entries from the Locations & Updates lists that are relevant to that Project. I have a lookup column in the Locations and Updates Lists where I am currently selecting the Project. I know Power Apps doesn't play super well with SP Lookup columns so I'm happy to do this another way if it would work better.

Basically, I need to filter all three lists on 'Project Name' and have them show associated fields on the Display Form. Is this possible?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report

Hi @sloth790 ,

If you only want to display them, you can do labels on Custom Cards using a Lookup. Forget about the Lookup column and just refer to the matching columns in both Lists directly. You can use ThisItem.MatchingFieldName for the main list field as it is in a Form.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report

Hi @sloth790 ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
sloth790 11 on at

Like (0)

Report

Thanks! To expand on what you said a bit, I removed the Lookup columns from my SharePoint lists and replaced them with a Single Line of Text column. My scenario had a main list "Projects", and it ended up with three sub-lists: "Updates", "Investments", and "Locations". I added a single line of text column in all three sub-lists and named it ProjName. I then inserted the name of the Project in this column that corresponded with the name in the "Projects" list.

Then, while selecting one of the sub-list galleries, I selected 'Items' in the dropdown. For my "Updates" list, I added the following text in the formula bar: Filter('Updates',ProjName='Projects Gallery'.Selected.Title)
Where:
Updates = Sub-list name
ProjName = The name of the column in the "Updates" list that held the project name that corresponded to the main list
Projects Gallery = Gallery for my main projects list.

Was this reply helpful? Yes No