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

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Top Solution Authors
Top Kudoed Authors
Users online (31,030)