You’re offline. This is a read only version of the page.
716
Hello Power Apps Community,
I hope you can help please.
In the CDS I have two entities: My Site, and the second one is Recovery Level. It's a one-to-many relationship. So one My Site record can have many Recovery Level records.
Using a canvas app, I have created two dropdowns, and connected them to the entities, so one dropdown is connected to the My Site entity (parent) and one is connected to the Recovery Level entity (child).
Can I use on the "Properties" tab the "Depends on..." option? So that when I select a record in the My Site dropdown (parent) it only shows me records for the Recovery Level (child) that are associated to the My Site record.
I tried this, but it's not showing me any records in the Recovery Level dropdown when I select a value in the My Site dropdown.
Any help would be greatly appreciated. Thanks very much,
Garry
I'm sorry, I was confused because there is another dependency setting at the solution area that controls constraints in solution components so that you have to have B if A is in the solution or you have to delete B before you can delete A.
Regarding the drop-down setting, it works, but it is very basic. and it is just a shortcut, as it writes the filter expression for you.
Typically when I do a dependent drop-down I want to filter based on a lookup/relationship, such as filtering a contact drop-down to contacts related to a selected account. You can't do that with the depends on link, because it doesn't see the lookup fields.
so if you have a simple filter scenario it can be a timesaver, but it is very limited. for more advanced filtering, such as filtering based on a lookup field, write the filter expression.
@GarryPope if that answers your question, please mark it a solution.
Hello @jlindstrom,
Thanks so much for replying, especially on a Saturday!
May I ask then, what is this "Depends on" property for? This seems, on paper, that this would be the perfect case to use in this scenario. Is it because the data source is CDS that this isn't working for me? I read the below article.
https://powerapps.microsoft.com/en-us/blog/configure-easy-dependent-drop-downs-in-powerapps/
Maybe I didn't explain myself correctly in my original question.
Thanks very much and enjoy your weekend,
Garry
Not exactly. Depends on field property creates a dependency in configuration for importing and removing solution components but doesn’t filter your drop down in canvas apps. You will need to filter the items property of the second dropdown based on the value of the first
Share
Report
All responses (
Answers (
