Answered

Automatically assign a default Combobox value in a form

(0) Share

Report

Posted on by nshaw75

440

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

WarrenBelz 153,779 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
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 440 on at

Like (0)

Report
Copy link

Link copied!

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 153,779 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@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 440 on at

Like (0)

Report
Copy link

Link copied!

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