Unanswered

Filtering a table where a field in a selected gallery matches the title of a column

(1) Share

Report

Posted on by JWHTX

Howdy,

I'm trying to create what I thought would be a fairly simple app that has three components: a gallery, an image, and a table. The app would be used by partners to sign into meetings and would list only people who've signed into the selected meeting.

The gallery is the main control and has a list of 20 meetings. It's connected to a SPO list we'll call Codes for brevity.
The image control displays a QR code depending on which meeting is selected.
The table control is connected a different SPO list, which we'll call Attendance.

Refer to the image below (and please disregard how ugly this is right now).

The gallery is used to select the meeting then display the corresponding QR code and table. Each meeting has a reference ID with a letter and a number (e.g., A1, G2). You can see in the gallery in my image above that Mass Care Services is O1 and Health and Medical is P1.

The QR code takes meeting participants to a sign-in form. Submitting the form triggers a flow that populates the Attendance list. It's one list for all 20 meetings. The list includes 20 Yes/No columns titled to match the corresponding reference ID in the gallery. When someone signs in for a meeting, it triggers a yes/no checkbox (default is no).

The trouble I'm having is filtering the table based on the selected meeting. I've been trying various solutions I've read in forums or watched in videos but haven't had any luck (the table in the image above isn't filtered at all).

So, essentially what I've been trying to do is come up with something that accomplishes "If Mass Care Services (O1) is selected, filter Attendance list to display only rows where the column titled O1 is true/yes."

I'd be happy to hear your thoughts on the matter. Please let me know if you have any questions.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (0)

Report

Hi

The # of times, people say stuff is easy, and then it doesn't work used to be funny, not Im just like, why think that at all lol until its done.

We also don't need a back story. I don't say this to be mean. But you have an issue and the more information you toss at us that is completely unrelated it just causes confusion. Its just feedback :-) ignore if you want

And nope, I cannot see as its too small :-). I am actually curious, when you save it and review your own post is it like super big for you? I am truly curious, I've never asked anyone before.

Ok, now last feedback, you wrote so much stuff that was completely irrelevant that you didnt supply the information that was important. follow me

The trouble I'm having is filtering the table based on the selected meeting.

I've been trying various solutions I've read in forums or watched in videos but haven't had any luck (the table in the image above isn't filtered at all ). (dont need it)

So, essentially what I've been trying to do is come up with something that accomplishes "If Mass Care Services (O1) is selected, filter Attendance list to display only rows where the column titled O1 is true/yes." <== again you aren't telling us the problem sorta until the very end when its not statiing the problem its you telling us what you tried.

, filter Attendance list to display only rows where the column titled O1 is true/yes."

So is the title 01 or true or yes? I can't tell

Fitler(Attendance, Title = OtherGallery.Selected.Title)

except and It doesnt say ANYWHERE if you have another column in list 1, that will just have 01 or are you saying its not about being EQUAL, its about whether there are any columns in list 2, where ITS value (whatever column that says 01) is in <== the expression in Gallery.Selected.Column

So you end up with

Filter(Attendence, Title in Gallery1.Selected.ColumnTtitle)

I believe this is what you want honestly but it took alot to guess to get there.

Was this reply helpful? Yes No
JWHTX 84 on at

Like (0)

Report

FLMike,

You are correct that I didn't clearly state that the Title column of the Codes SPO list included the reference IDs (e.g., A1, G2, O1). Each of these IDs has a corresponding column in the Attendance SPO list. Those columns are set up as the Yes/No type.

Your suggestion, Filter(Attendance, Title = OtherGallery.Selected.Title), is where I started, and it never worked quite right. Having played around with it some this weekend, here's what does work for me:

If(
    Gallery.Selected.Title = "A1",
    Filter(
        Attendance,
        A1 = true
    )

I'm trying to avoid adding 19 additional Else statements to that. I need both instances of A1 in that example to be dynamic. If I click meeting K2 on the gallery, I need it to filter out all of the instances where column K2 is false.

I tried making a variable in the OnSelect property of the gallery, but that gave me an incompatible types for comparison error (text, boolean).

Was this reply helpful? Yes No