Combo Box Dataverse Choices

(1) Share

Report

Posted on by ctedesco3307

938

invoice Status is a choice list - Dataverse

trying to create a combo box of distinct values - getting error

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Suggested answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @ctedesco3307,

Since Invoice Status is a Dataverse Choice column, it’s not stored as plain text, it returns a record (with properties like .Value). That’s why using Distinct() directly on the column throws an error. It will return only the choices from the column, so you don’t need to use DISTINCT.

Choices([@'AP Invoice Header'].'cr1bf_Department') //AP Invoice Header - Replace with your table name if it's wrong. //cr1bf_Department - Replace with your invoice column scheme name.

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

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

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping!

Was this reply helpful? Yes No
ctedesco3307 938 on at

Like
a
(0)

Report
Copy link

Link copied!

@Kalathiya - thank you for your response but I still have the same issue

Choices(' AP Invoice Headers'.'xxxxx_invoicestatus').Value

returns the same thing

Was this reply helpful? Yes No
Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @ctedesco3307,

On hover it is expected because Choices() returns a table (complex data type), so Power Apps shows it as unsupported in that preview. However, if you run the app in Play mode and check the dropdown, you should see that it’s loading the correct options. The formula is working as expected.

Choices('Status Reason (Courses)') //Status Reason - Replace with your column name //Courses - Replace with your table name

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

Was this reply helpful? Yes No
Suggested answer

ctedesco3307 938 on at

Like
a
(0)

Report
Copy link

Link copied!

@Kalathiya

Thank you!

They were all blank until I added value in the field selection - this is what worked

Choices(' AP Invoice Headers'.xxxxx_invoicestatus).Value

Was this reply helpful? Yes No
Verified answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @ctedesco3307,

Sometimes the value does not display by default, so we need to set it manually in the ComboBox field properties.

Also, there is no need to expand the value in the Items property. If the options are not appearing in the ComboBox, you can configure them directly from the ComboBox field properties.

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

Was this reply helpful? Yes No