Restrict two choices from dropdown menu

[ddluizaud]

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 

[AJ_Z · Accepted solution]

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

[ddluizaud]

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

[AJ_Z]

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