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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Power Apps "Depends On...
Power Apps
Unanswered

Power Apps "Depends On" in Drop Down doesn't match Formula in Data Items

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

I had never used the "Depends On" function in Power Apps - I just put in the filter(s) in the Data /Items fx. 

 

Filter([Data Table], [Column Name1] = [Drop Down Control1].Selected.Result && [Column Name2] = [Drop Down Control 2].Selected.Result)

 

When you click on the "Depends On" link it shows me a parent control that I didn't even reference in my formula, ignores the second filter control., and matches a completely different column (not in my formula). Is that normal? My application still works as I expect, but why would that "Depends On" junk be in there if it isn't used?

 

Also, with formulas, I can reference other types of controls (like a text input for a partial name search), that isn't even an option in the "Depends On." Is this some type of wizard for point and click Power Apps functionality? If so, we really should be able to remove it if it is pulling in incorrect junk.

Categories:
I have the same question (0)
  • v-siky-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

     

    Thank you for your feedback and I agree with you. The depend on function is actually used to quickly establish the dependence between two dropdown, and it can be correctly displayed when the formula conforms to the dependence conditions. 

    For Parent Control, it's similar to Dropdown in the app, showing the first option by default. But it has no effect on the actual use of the formula or app. 

    If you want like this design, please submit an idea to Microsoft in PowerApps Ideas Forum.

    Hope this helps.

    Sik

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 392

#2
WarrenBelz Profile Picture

WarrenBelz 364 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 271 Super User 2026 Season 1

Last 30 days Overall leaderboard