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

GarryPope
Impactful Individual
Impactful Individual

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.

View solution in original post

GarryPope
Impactful Individual
Impactful Individual

Hello @jlindstrom,

Thanks for the explanation, that's perfect.

Garry 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,635)