Show selected items in gallery

[katunar]

Hello everybody,

I am currently working on an app for reserving devices for events. I have 3 tables in my data source, one with the event list including the event ID, one for the device list including the device ID and one for the realtionship between the 2 previous including the device ID and event ID in it. I have a gallery with all my events. When I select an event, a new screen opens and I can edit its informations. In this editing screen, there is a button that navigates to another screen. In this screen, I want to display a gallery which shows the devices selected for this event.

Can anybody help?

[v-xida-msft · Accepted solution]

Hi @katunar ,

Could you please share a bit more about your data source? Is it a Excel table?

Could you please share a screenshot about your app's configuration?

Further, do you want to display related devices within the second Gallery based on the selected event within the first Gallery?

Based on the needs that you mentioned, I think the Filter function in PowerApps could achieve your needs. I have made a test on my side, please take a try with the following workaround:

Set the Items property of the first Gallery (Gallery1) to following:

'Event Table'

Set the Items property of the second Gallery (Gallery2 in your new Screen) to following:

Filter(
        'Device Table',
        'device ID' in Filter('Relationship Table', 'event ID' = Gallery1.Selected.'event ID').'device ID'
)

Note: The 'event ID' and 'device ID' represents the columns in your 'Relationship Table'.

More details about Filter function in PowerApps, please check the following article:

Filter function

Best regards,

[katunar]

Hello @v-xida-msft 

thank you for your reply. The solution works perfectly. Let me know if you would still like to know more about my app configuration. Otherwise have a good day.

Thank you very much.