cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ddluizaud
Regular Visitor

Restrict two choices from dropdown menu

I would like to restrict the choices from a drop down menu to 3 choices.

Currently I have 5 choices:

  1. In Progress
  2. Pending
  3. Finished
  4. Approved (it's not to appear)
  5. In Revision (it's not to appear)

Does anyone know how to do this?

I have tried: Filter(Choices(MyDataSource.Status),Value="In Progress" and "Pending" and "Finished") and sooo many ways 

but it doesn't work I'M FREAKING OUT

 

Thanks 

1 ACCEPTED SOLUTION

Accepted Solutions
AJ_Z
Super User
Super User

Hey It would be useful to understand the datasource as that can play a factor in this sometimes but firstly I can see a slight issue with the logic try this:

 Filter(Choices(MyDataSource.Status),Or(Value="In Progress", Value= "Pending", Value= "Finished"))

I have done the above with the assumption a Microsoft List/Sharepoint List is your source.
This needs to be an Or and not an And



Signature:


If you appreciated my comments/responses please be sure to Like/Kudo them it really does make me smile 🙂 !
Link to the Power Platform Professionals United Kingdom User Group:

https://powerusers.microsoft.com/t5/Power-Platform-Professionals/gh-p/PowerPlatformProfessionalsUnit...

View solution in original post

3 REPLIES 3
AJ_Z
Super User
Super User

Hey It would be useful to understand the datasource as that can play a factor in this sometimes but firstly I can see a slight issue with the logic try this:

 Filter(Choices(MyDataSource.Status),Or(Value="In Progress", Value= "Pending", Value= "Finished"))

I have done the above with the assumption a Microsoft List/Sharepoint List is your source.
This needs to be an Or and not an And



Signature:


If you appreciated my comments/responses please be sure to Like/Kudo them it really does make me smile 🙂 !
Link to the Power Platform Professionals United Kingdom User Group:

https://powerusers.microsoft.com/t5/Power-Platform-Professionals/gh-p/PowerPlatformProfessionalsUnit...

ddluizaud
Regular Visitor

IT WORKED, THANK YOU SO MUCH I LOVE U!!! (my data source was actually Sharepoint haha)

Haha I am happy to hear that 🙂 ! have a Fantastic day and good luck with your App!



Signature:


If you appreciated my comments/responses please be sure to Like/Kudo them it really does make me smile 🙂 !
Link to the Power Platform Professionals United Kingdom User Group:

https://powerusers.microsoft.com/t5/Power-Platform-Professionals/gh-p/PowerPlatformProfessionalsUnit...

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 (3,963)