View My Drafts
I create an application with powerapps, and i need to filter between 3 combobox "Country" " Project" and "Contract"
. Like you can see in the picture. I want to display the projects associated with the chosen country & Contract, and the sae thing for the 3 combobox. How can i do this please ? And i have another question, is it necessary that the 3 columns must be in the same sharepoint list so that I can filter between them ?
Thank you !!
Here is some research I did on what I called Parent - Child hierarchy lookup filtering. It is D365 centric but D365 is really a PowerApp.
Create dependent/cascading lookup fields. For example, your first lookup field would point to the cars entity, when "Honda" is chosen, the second lookup will only show the Make options for Honda. The third Model lookup field would only show the options for the Honda Accord.
Filtered Lookups vs. Dependent Option Sets Brings up both options and shows Filtered Lookups with a link to the Microsoft Documentation on Dependent Option Sets
Filtered Lookups: This is the OoB functionality but filters out values based on the relationship so entity to entity
Dynamics 365: Lookup Field Filtering
How to filter lookups without custom code in Dynamics 365 Customer Engagement
Filter Lookup Field Without Writing Code using OOB Future in MS Dynamics 365 CRM
FILTERING LOOKUP FIELDS IN DYNAMICS 365
Self-referential relationship. There is also a similar relationship on the account entity called Parent Account -which is a lookup to account and then also have a Child Account subgrid.
Dependent Option Sets - This solution requires hard coding values.
FILTERING LOOKUPS BASED ON OPTION SET (PICKLIST) FIELD IN DYNAMICS CRM This solution allows you to use Option Sets but requires Java Script
Sample: Create dependent OptionSets (picklists) Microsoft Documentation
3rd party Options
Dependent OptionSet Generator Found on UG discussion here
PCF Dependent Optionset Found on UG discussion here
GITHub - Solution has been archived