If form is New, limit the combobox list to 1 predetermined value

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a workflow that requires a new item to be entered initially with the Status = Open.

So let's say my Status can be = Open, In Progress, Closed.
I load these options in the comboBox with:

Items:

Choices([@'My Sharepoint List'].'Ticket Status')

Default Selected Items:
Parent.Default

This works great but how can I force the comboBox to display Open and hide the other two options when the form is New?

I tried:
Default Selected Items:

If(EditForm1_.Mode = FormMode.New,Filter('My Sharepoint List','Ticket Status'.Value="Open"),Parent.Default)

But I get an error saying

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

Jcook 7,783 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @Anonymous

Use this on the DefaultSelectedItems

If( EditForm1_.Mode = FormMode.New, { Value: "Open" }, Parent.Default)

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Just curious, would it not be easier to set the default item to open always, and just hide the combo box via visibility, or set its mode to disabled or view when form mode is new? That way your user's wouldn't have a clickable combo box with only option inside of it for new forms, seems like easier way to accomplish this.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks. Yes, that would indeed make more sense but the truth is, I try to break down my questions and make them very simple to understand and respond to.

In my real project, that status depends on many more factors and each does some action.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Thanks. I also had to do:

If( EditForm1_.Mode = FormMode.New, ["Open"], Parent.Default)
in the Items property to limit to Open only.

Was this reply helpful? Yes No