I would like to restrict the choices from a drop down menu to 1 choice.
Currently I have 6 choices:
For someone that is creating a new item I want them to only have the possibility to choose "In Progress".
Does anyone know how to do this?
I have tried: Filter(Choices(MyDataSource.Status, StartsWith("In Progress"))) but this doesnt work.
Solved! Go to Solution.
Hi @TroGun18 ,
Which kind of data source is 'WBS Masterdata'?
What is the type of Status column? Option set?
Can you show more details about the error infomation?
The source is Sharepoint and the status columns is an option (choices).
Error 1: Name isn't valid. This identifier isn't recognized. Location: DatacardValue241.Items
Error 2: Invalid use of '.' Location: DatacardValue241.Items
Error 3: Invalid Argument Type. Location: DatacardValue241.Items
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand