cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GarryPope
Impactful Individual
Impactful Individual

"Depends on" property using CDS data

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

1 ACCEPTED SOLUTION

Accepted Solutions

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.

View solution in original post

4 REPLIES 4

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

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

 

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 for the explanation, that's perfect.

Garry 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (2,571)