cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ianallen13V2
Helper II
Helper II

sorting an excel table for drop down

I'm sure this is an easy question for this group, but I have a small table in Excel that I am using for a drop down (See below): 

ianallen13V2_0-1637256992407.png

 

However, I want to find a way to filter so that for another drop down, it only shows Quality Reviews #1-4 and excludes #5.  How would I write that and/or is that possible?

 

Thank you! 

2 ACCEPTED SOLUTIONS

Accepted Solutions
StalinPonnusamy
Super User
Super User

Hi @ianallen13V2 

 

Pls try this

Filter(ExcelTableName,'Quality Reviews' <> "Quality Reviews #5").'Quality Reviews'

 

View solution in original post

ianallen13V2
Helper II
Helper II

That was it!  Thank you so much!! 

View solution in original post

2 REPLIES 2
StalinPonnusamy
Super User
Super User

Hi @ianallen13V2 

 

Pls try this

Filter(ExcelTableName,'Quality Reviews' <> "Quality Reviews #5").'Quality Reviews'

 

ianallen13V2
Helper II
Helper II

That was it!  Thank you so much!! 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,653)