cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tjalui
Resolver I
Resolver I

Filter Gallery based on lookup field of form

Hi 

 

I have Data Source as Common Data Service, i have a screen in which i have added a form with a different source. In the form there is a lookup field, i want to filter a gallery (which is in the same screen but with different source) with the value in the Lookup Field.

Screenshot_1.png

 

I want to filter the gallery on the basis of the value selected in the lookup field.

1 ACCEPTED SOLUTION

Accepted Solutions
v-xida-msft
Community Support
Community Support

Hi @tjalui ,

Could you please share a bit more about the "Role Price" data source you mentioned? Is it also a CDS Entity?

Do you want to filter your Gallery Items based on the selected value within the Price List LookUp field? Does the "Price List" LookUp field reference values from the "Role Price" data source?

 

If the "Price List" is a LookUp field in your "Quote Project Price Lists" Entity, which reference values from the "Role Price" Entity, please consider take a try with the following workaround:

Set the Items property of the GalleryRole to following:

Filter('Role Prices', 'Unique Identifier Column' = PriceListComboBox.Selected.'Unique Identifier Column')

Note: The 'Unqiue Identifier Column' represents the Unique Identifier column in your 'Roles Prices' Entity.

 

If the 'Role Prices' is not a CDS Entity, and there is a relationship between the "Quote Project Price Lists" Entity and the "Role Prices" data source, please modify above formula as below:

Filter('Role Prices', FilteredColumn = PriceListComboBox.Selected.DisplayColumn)

Note: The FilteredColumn represents the column in your 'Role Prices' data source, which used to compare with the selected value within the Price List ComboBox. The DisplayColumn represents the column you used as display value within the PriceList ComboBox.

 

If the 'Price List' column is a Option Set column or Two Option column in your "Quote Project Price Lists" Entity, please consider modify above formula as below:

Filter('Role Prices', FilteredColumn = PriceListComboBox.Selected.Value)

 

Please consider take a try with above solution, then check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-xida-msft
Community Support
Community Support

Hi @tjalui ,

Could you please share a bit more about the "Role Price" data source you mentioned? Is it also a CDS Entity?

Do you want to filter your Gallery Items based on the selected value within the Price List LookUp field? Does the "Price List" LookUp field reference values from the "Role Price" data source?

 

If the "Price List" is a LookUp field in your "Quote Project Price Lists" Entity, which reference values from the "Role Price" Entity, please consider take a try with the following workaround:

Set the Items property of the GalleryRole to following:

Filter('Role Prices', 'Unique Identifier Column' = PriceListComboBox.Selected.'Unique Identifier Column')

Note: The 'Unqiue Identifier Column' represents the Unique Identifier column in your 'Roles Prices' Entity.

 

If the 'Role Prices' is not a CDS Entity, and there is a relationship between the "Quote Project Price Lists" Entity and the "Role Prices" data source, please modify above formula as below:

Filter('Role Prices', FilteredColumn = PriceListComboBox.Selected.DisplayColumn)

Note: The FilteredColumn represents the column in your 'Role Prices' data source, which used to compare with the selected value within the Price List ComboBox. The DisplayColumn represents the column you used as display value within the PriceList ComboBox.

 

If the 'Price List' column is a Option Set column or Two Option column in your "Quote Project Price Lists" Entity, please consider modify above formula as below:

Filter('Role Prices', FilteredColumn = PriceListComboBox.Selected.Value)

 

Please consider take a try with above solution, then check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (59,119)