"Depends on" property using CDS data

(0) Share

Report

Posted on by CU01081947-0

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

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Joel CustomerEffective 3,224 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
CU01081947-0 716 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Joel CustomerEffective 3,224 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
CU01081947-0 716 on at

Like (0)

Report
Copy link

Link copied!

Hello @jlindstrom,
Thanks for the explanation, that's perfect.
Garry

Was this reply helpful? Yes No