Dropdown Default for Dataverse Choice

(0) Share

Report

Posted on by BenKraft

176

I have a dropdown whose Items are the (nonglobal) choice field options of a table "Magnet Board - Magnets":

Choices([@'Magnet Board - Magnets'].'Shortage State')

I want its Default property to populate with the current shortage state of a magnet record I have saved to a global variable, _SelectedMagnet, which is populated with a choice in said field:

My thought is that I would set it to something like this:

_SelectedMagnet.'Shortage State'

But it gives the error: Invalid formula. Expected a value compatible with 'Items'.

Is this not of the same choice type? I tried using .Value on the choice to no avail. Am I missing something obvious?

Categories:

Building Power Apps

Error handling

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

BenKraft 176 on at

Like
a
(0)

Report
Copy link

Link copied!

Come to think of it, I'm not even sure how you would set a static default for this dropdown, even something like:

[@'Shortage State (Magnet Board - Magnets)'].Partial

doesn't work.

Was this reply helpful? Yes No
Suggested answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hello @BenKraft,

Could you please try this way?

LookUp(Choices([@'Magnet Board - Magnets'].'Shortage State'),Value='Shortage State (Magnet Board - Magnets)'.Partial)

---------------------------------------------------------------------------

Glad it helped 🙂
If this fixed your issue, please click “Does this answer your question?” to mark it as verified so others can find the solution easily.
A Like 👍 is always appreciated, and I’m around if you need more help @Kalathiya

Was this reply helpful? Yes No
Suggested answer

11manish 3,333 on at

Like
a
(0)

Report
Copy link

Link copied!
If this is a Dropdown control:

Default = _SelectedMagnet.'Shortage State'.Value

If this is a ComboBox control:

DefaultSelectedItems = [_SelectedMagnet.'Shortage State']

The error "Expected a value compatible with 'Items'" usually indicates that the control is expecting a choice record from the Choices table, but it's receiving either

text or a record of a slightly different schema. Matching the record structure (or using DefaultSelectedItems for ComboBoxes) typically resolves the issue.

Was this reply helpful? Yes No
BenKraft 176 on at

Like
a
(0)

Report
Copy link

Link copied!

@11manish As described in the question, this is a dropdown and something like

_SelectedMagnet.'Shortage State'.Value

Doesn't work:

Was this reply helpful? Yes No
Suggested answer

BenKraft 176 on at

Like
a
(0)

Report
Copy link

Link copied!

@Kalathiya

This helped me find the solution that works for the most part!

I ended up using:

{Value: _SelectedMagnet.'Shortage State'}

I believe this works because instead of specifying an actual choice (what _SelectedMagnet.'Shortage State' does), the Defaults property expects a record with a field "Value" because that's the type of table Choices() creates.

So, in that regard, that means there is a difference between

[@'Shortage State (Magnet Board - Magnets)'].Partial

and

LookUp(

Choices([@'Magnet Board - Magnets'].'Shortage State'),

ThisRecord.Value = [@'Shortage State (Magnet Board - Magnets)'].Partial

)

Because one is a choice itself and the other is a record containing that choice under the "Value" field.

For the static use case, you can similarly use something like

{Value: [@'Shortage State (Magnet Board - Magnets)'].Partial}

Was this reply helpful? Yes No
11manish 3,333 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi BenKraft,

Please try below :

Default : JSON(_SelectedMagnet.'Shortage State')

or

JSON(First(Choices([@'Magnet Board - Magnets'].'Shortage State')))

Was this reply helpful? Yes No