Answered

Automatically assign a default Combobox value in a form

(0) Share

Report

Posted on by nshaw75

438

Hi I am building a permit management app and on my "OpenNewPermit" screen I have a form, linked to a sharepoint list, in which I want to set a default value of "Open" for the status. When I have put the field into the form it has automatically assigned a Combobox and I have used the following formula in the Items property - Filter(Choices([@'Permit Tracker'].Status),ThisItem.Status="Open")

Alas this isn't working and any help would be much appreciated.

I have the same question (0)

All responses (4)

Answers (1)

WarrenBelz 152,811 Most Valuable Professional on at

Like (1)

Report
Re: Automatically assign a default Combobox value in a form

HI @nshaw75 ,

If you simply want "Open" as the Default choice, in the DefaultSelectedItems of the Combo Box

{Value: "Open"}

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
nshaw75 438 on at

Like (0)

Report

Re: Automatically assign a default Combobox value in a form

Hi @WarrenBelz
Thanks, I am getting an error still. Incompatible types for comparison. It suggests I convert the value 🤔 I am assuming this may be to do with it being a Choice field.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 152,811 Most Valuable Professional on at

Like (1)

Report
Re: Automatically assign a default Combobox value in a form

@nshaw75 ,

The Items should be

Choices([@'Permit Tracker'].Status)

and the DefaultSelectedItems (as I posted)

{Value: "Open"}

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
nshaw75 438 on at

Like (0)

Report

Re: Automatically assign a default Combobox value in a form

Fantastic, As soon as I saw saw your solution, I realised I had made the schoolboy error of deleting my formula and replacing it with the default one .

Thanks again @WarrenBelz

Was this reply helpful? Yes No