Announcements
In PowerApp form, I have a dropdown named 'Status' with 3 options ('Created', 'In-progress', 'Closed'). I want to show only 'Created' option when the FormMode=New. In case of FormMode = Edit, the remaining 2 options should be listed.
I want the user to see only the "Created" option from in FormMode=New. In case of Edit mode, he should be able to select between "In-Progress" and "Closed". Can we tweek the code a little more to achive that ?
My query is in continuation to the solved problem described here: https://powerusers.microsoft.com/t5/Building-Power-Apps/How-to-restrict-change-of-value-of-choice-field-based-on/m-p/2428634#M605477
Hi, try this.
If(EditForm1.Mode= FormMode.New, Filter( Choices(LISTNAME.CHOICECOLUMNANME), Value = "Created" ), Switch( //Adjust choice column name & list names below ThisItem.CHOICECOLUMNANME.Value, "Closed", //Only closed should be available Filter( Choices(LISTNAME.CHOICECOLUMNANME), Value = "Closed" ), "In-Progress", //Created should no longer be available Filter( Choices(LISTNAME.CHOICECOLUMNANME), Value <> "Created" ), //Display all options when the value is blank or equal to Created Choices(LISTNAME.CHOICECOLUMNANME) ))
Thank you soo much..
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 402 Super User 2026 Season 2
Mohsin Ali 328
WarrenBelz 296 Most Valuable Professional
