web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / "Depends on" property ...
Power Apps
Answered

"Depends on" property using CDS data

(0) ShareShare
ReportReport
Posted on by 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 have the same question (0)
  • CU01081947-0 Profile Picture
    716 on at

    Hello @jlindstrom,

    Thanks for the explanation, that's perfect.

    Garry 

  • Verified answer
    Joel CustomerEffective Profile Picture
    3,224 on at

    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.

  • CU01081947-0 Profile Picture
    716 on at

    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

     

  • Joel CustomerEffective Profile Picture
    3,224 on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
Kalathiya Profile Picture

Kalathiya 428

#2
WarrenBelz Profile Picture

WarrenBelz 374 Most Valuable Professional

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 333 Super User 2025 Season 2

Last 30 days Overall leaderboard