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 / Filtering out values i...
Power Apps
Answered

Filtering out values in dropdown based on values in excel column

(0) ShareShare
ReportReport
Posted on by

man329_1-1616116210477.png

I have combo box drop down for "section" which has values from 1 to 9.

man329_2-1616116295244.png

I have excel file where the these values are getting submitted.

*I am trying to remove(hide) the values in "section" drop down if its already there in "Rack" column. I tried using countrows and lookup value commands but no luck. Can you guys please guide me in this.

Thanks.

 

Categories:
I have the same question (0)
  • Verified answer
    rubin_boer Profile Picture
    4,843 Super User 2024 Season 1 on at

    hi @man329 with your rack info as 2-3-5- consider adding this to the dropdown 

    Items = Filter(ForAll(Sections,If(Not(YourColumnValue in Split("2-3-5-","-")),YourColumnValue)),YourColumnValue <> Blank())

     

    This is what will be returned

     

    rubin_boer_0-1616138037266.png

     

    Hope this will help.

     
     

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 483

#2
WarrenBelz Profile Picture

WarrenBelz 399 Most Valuable Professional

#3
11manish Profile Picture

11manish 327

Last 30 days Overall leaderboard