Answered

Filtering a Gallery Based on the Selection of Another Gallery

(0) Share

Report

Posted on by JacksonG

I have an app which displays all of the room numbers within a facility. When you select a room in the main gallery, you are taken to a details screen relevant to that room number. I have a second gallery within that details screen which I want to display the owners of that area in. Is there a way to filter the details screen gallery, which is taking the user information from a SP multi-select people column based on the room selected on the home page?

Here is the current items property of the gallery that I want to filter based on the other gallery.

Choices([@'CB Locations'].Owners)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

Ami K 15,687 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@JacksonG - you could apply the below for example onto the Items property of the second Gallery control:

LookUp( 'CB Locations', ID = Gallery1.Selected.ID, Owners )

And update the Text property of one of the Labels to:

ThisItem.DisplayName

Was this reply helpful? Yes No
JacksonG 40 on at

Like
a
(0)

Report
Copy link

Link copied!

You're awesome, Amik. Thank you!

Was this reply helpful? Yes No
JacksonG 40 on at

Like
a
(0)

Report
Copy link

Link copied!

I'm also trying to launch Outlook and compose a new email to the owner that was selected within the gallery. Is that something I can do?

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@JacksonG - sure. You can apply the below for example onto the OnSelect property of the second Gallery control:

Launch("mailto:" & ThisItem.Email)

The following tutorials should also be useful to you:

https://www.youtube.com/watch?v=vpYkOccwn4Y

https://www.youtube.com/watch?v=GoF3vfP3YTM

Was this reply helpful? Yes No