I found this very helpful! One issue that I have found is when I change the column with the controlling value, the previous value still remains in the dependent column. Is there any way to clear out the dependent column value and require the user to reselect the dependent value? Eg. If i change the company, the contact needs to be re-selected.
This is straight forward new table creation. 1) create a table that will contain the filtered/cascaded values you want to lookup 2) define a column that holds the value you want to lookup 3) define a column that references the "filtering" value e.g. if the value you want to filter is a list of states/provinces within a country that you select, this will be a reference to a table that contains the list of countries. 4) populate the table with the states/provinces you want to be able to look up. For each row, pick the country it is related to. Use this table as the source for your cascaded/filtered lookup.
Thank you for this! Is there a way to have the dropdown automatically show the related records without also clicking on the magnifying glass? That seems like something many people would not do. Might generate lots of questions.
This is a great set of video for Power Page, surely my first introduction and I am loving it. May just request that you update/refresh your play list to include all your other related videos and finally to sequence them so viewers don't have to go around looking for the other videos not in the playlist. Many thanks.
Thank you, been switching to classic and never realised its been added in the modern look 👌👍. I have 4 lookups cascading/filtering, is there another way of controlling the On Change instead of the business rule, so that if the parent changes then the child is cleared. Thanks
To be clear - this solution uses tables (i.e. tables that must be developed), not the built-in choice/choices functionality for dropdowns. This is fine but I think it's important that people understand the difference. The value in choice/choices is that PowerApps builds/manages the data storage functionality automatically (but does not support cascading drop-down functionality, at the time of this writing). In this solution the developer must create the tables.
I found this very helpful! One issue that I have found is when I change the column with the controlling value, the previous value still remains in the dependent column. Is there any way to clear out the dependent column value and require the user to reselect the dependent value? Eg. If i change the company, the contact needs to be re-selected.
Please where can I find the video where you set up the tables to allow cascading lookups?
I am searching for the same.
This is straight forward new table creation.
1) create a table that will contain the filtered/cascaded values you want to lookup
2) define a column that holds the value you want to lookup
3) define a column that references the "filtering" value e.g. if the value you want to filter is a list of states/provinces within a country that you select, this will be a reference to a table that contains the list of countries.
4) populate the table with the states/provinces you want to be able to look up. For each row, pick the country it is related to.
Use this table as the source for your cascaded/filtered lookup.
Thank you for this! Is there a way to have the dropdown automatically show the related records without also clicking on the magnifying glass? That seems like something many people would not do. Might generate lots of questions.
There are other controls you can download to convert it instead to a drop-down box instead of a search that should fulfill the requirement.
This is a great set of video for Power Page, surely my first introduction and I am loving it. May just request that you update/refresh your play list to include all your other related videos and finally to sequence them so viewers don't have to go around looking for the other videos not in the playlist. Many thanks.
Will do!
Thanks for sharing❤
This was cool beans. Next up for me is organizing all the view edit create forms for my power page. Video?
Thank you, been switching to classic and never realised its been added in the modern look 👌👍. I have 4 lookups cascading/filtering, is there another way of controlling the On Change instead of the business rule, so that if the parent changes then the child is cleared. Thanks
No problem 👍
Why don't my custom relationships show up in the filter dropdown? Please help :-)
Interesting, Thanks
To be clear - this solution uses tables (i.e. tables that must be developed), not the built-in choice/choices functionality for dropdowns. This is fine but I think it's important that people understand the difference. The value in choice/choices is that PowerApps builds/manages the data storage functionality automatically (but does not support cascading drop-down functionality, at the time of this writing). In this solution the developer must create the tables.