How do I set the default value of a combobox?

(0) Share

Report

Posted on by MZ_980

118

Hello,

I have a combobox in which the items are populated from a Dataverse table lookup.

One of the fields that I'm querying is a Choices field. On my form, I have an editable combobox in which I'm able to display the choices with the following formula: Choices('Commission Type').Value. However, I don't know how to set the DefaultSelectedItems property with the choice that is in the Dataverse table.

A related question is that if the user changes the selected item in my Canvas App, what is the Patch syntax to update the Dataverse table record?

The following code is in the OnStart property of my App:

Lookup:

Set(ProductRecord,LookUp(Products, Product = GUID("<guid>")));

The code I tried to use for the DefaultSelectedItems property is

ProductRecord.'Commission Type'

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @z_mike_90,

Could you try the following code in the DefaultSelectedItems of your combobox:
LookUp( Choices('Commission Type'), Value = ProductRecord.'Commission Type' )

If this solves your question, would you be so kind as to accept it as a solution.
Thanks!

Was this reply helpful? Yes No
Verified answer

LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
To answer the related question: If you want to update the record as soon as the user selects another item in the dropdown (or removes the selection), you will need to add some code on the OnChange of the combobox.

Patch( Products, ProductRecord, {'Commission Type': Self.Selected.Value} )

If you want to patch the record when clicking a button instead of the OnChange, you will have to swap Self to the combobox name. Feel free to adjust the code to your needs.

I hope this helps!

Was this reply helpful? Yes No
MZ_980 118 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks so much! Both of your solutions worked like a charm.

Was this reply helpful? Yes No