Show Filter columns based on another Gallery item

(0) Share

Report

Posted on by Su27

I have two Galleries that use two separate data sources. In Gallery1 user selects one item. The selected item has a column called Computer that can have more than one for each item. The data source for Gallery1 has a lookup column to the datasource of Gallery2 which is computers.

I want the User to be able to select item from Gallery1 and see the list of computers associated with the selected item in Gallery2. I would like to see the items in Gallery2 so that user can take action on each of the computers i.e approve/decline.

This is what I tried:

Filter(Gallery2DataSource,ColumnName=LookUp(Gallery1DataSource,GUID=varItem.GUID,ColumnName).ColumnName)

The datasource is dataverse and app is hosted in Dataverse for teams.

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Su27 ,

Do you want to filter the records in gallery2 that have the same computer name based on the value of the lookup column in gallery1's data source?
Please try this:
Filter(Gallery2DataSource,ComputerColumn=Gallery1.Selected.LookUpColumnName.ComputerColumn)

Best regards,
Rimmon
Su27 28 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks alot this actually solves it.