Answered

Gallery Display

(0) Share

Report

Posted on by haqian

Hello! So one of the pages of my app has two galleries displayed, each synced to a different table. My two tables both have an "ID" and the information that go together have the same ID (for example, task 1 has an ID of 12345 and the steps that go with that task also have the ID of 12345). I currently have the second gallery with the code Filter(Task1, 'Step ID' = MasterGallery.Selected.'Test ID') to display the correct data with the correct task. However, nothing displays in the second gallery no matter what is selected from the first. Does anyone know how to fix this?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

haqian 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Update: So I changed the IDs to the words "TEST" to see if changing the numbers to a word works, and it did. Is there a reason why the number combination doesn't work?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @haqian

It sounds like a disambiguation issue. If the column names are the same in two tables, you can use RenameColumns() to change one so that the comparison will still work. Something like

Filter( RenameColumns( Task1, "'Step ID'","SID" ), SID = MasterGallery.Selected.'Step ID' )

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @haqian ,

Could you please share a bit more about the formula that you typed within the Items property of the MasterGallery? Does it connect to the Task1 data source?

Based on the formula that you mentioned, I think there is something wrong with it. I guess that you want to display related Steps in your Gallery2 based on the selected Task in your Gallery1, is it right?

On your side, you should modify your formula within the Items property of the second Gallery to following:

Filter( 'Steps Table', 'Step ID' = MasterGallery.Selected.'Test ID' )

Note: I assume that the 'Test ID' represents the ID column in your first table -- Task1. And the MasterGallery is connected to your Task1.

Also please make sure the 'Step ID' and the 'Test ID' are in same Data Type.

Please try above solution, check if the issue is solved.

Regards,

Was this reply helpful? Yes No