Unanswered

Unable to display values in combo box or dropdown list from choice column (Dataverse)

(1) Share

Report

Posted on by JonKho

Hi all

I need help on this issue with loading values to the combo box from one of the columns which is the default 'Status Reason'. I am trying to display records through text boxes, combo boxes and date pickers. You can refer to the screenshot shown below.

2022-05-29 22.37.21.png

I tried using the same fx code for text boxes and date picker which worked but it is not working for the combo box.

Screenshot 2022-05-29 at 10.21.42 PM.png

Here are the table and column details

Screenshot 2022-05-29 at 10.27.40 PM.png

Screenshot 2022-05-29 at 10.24.53 PM.png

Note: I referred to the posts shown below.

1) Solved: Re: Combo Box Choices Search - Power Platform Community (microsoft.com)Solved: Re: Combo Box Choices Search - Power Platform Community (microsoft.com)

2) Solved: Filter Dataverse table with Choice Column. Use tab... - Power Platform Community (microsoft.com)

Thank you for reading this post and I look forward to the replies and correct answer.

Regards

Jon

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (0)

PowerPuffKK 316 on at

Like (1)

Report
Hi @JonKho ,

Comboboxes with Choice columns in Dataverse work slightly differently which is why you're having issues (been there, done that!)

If you want to display the Combobox standalone, you'll need to use this formula:

Choices(Contacts.'Status reason')
Contacts is the name of my table, and Status Reason is the name of my choices.

If you want to use the Combobox within the gallery, you'll need to adjust it slightly to:

Choices(ThisItem.'Status reason')

Hope this helps - please mark it as a solution if it does to help future forum visitors.

Thanks
Kristine 😊

Was this reply helpful? Yes No
JonKho 11 on at

Like (1)

Report

Hi @PowerPuffKK

Thank you for the reply.

I did tried that previously and unfortunately it does not work as I wanted to correct records to be displayed.
Refer to the screenshots shown below.

Table records
Thank you.

Regards
Jon

Was this reply helpful? Yes No
JonKho 11 on at

Like (1)

Report

Hi all

I have tried to use drop down list but I met with another road block.

Edit:
I managed to display the results through dropdown list and combo box using lookup function. Refer to the screenshots below for more information.

Using Dropdown List

Using Combo Box
Fortunately, I was able to use collection feature for dropdown list to select the choices found in choice column, 'Status Reason'.

1)Setup the collection details.

2) Select the collection as datasource to allow values to be selected and also enter the fx code on lookup to load all the records according to the primary key.

3) Able to choose the values

But I am unable to list out the choices values for combo box even though I tried using choices and collection functions.

I would appreciate if someone can assist me with this.

Thank you.

Regards
Jon

Was this reply helpful? Yes No
iAm_ManCat 18,228 Most Valuable Professional on at

Like (0)

Report

Hi,

In the normal properties pane (i.e. not the advanced tab you are on), there is an option for fields which determines how it is displayed, I would gather from your screenshots that the wrong items are being displayed as you have not selected which items to display from the formula @PowerPuffKKgave you.

You should be able to change these to have it display the correct values instead of [object] [object] or the serial number column that it defaulted to.

Cheers,

Was this reply helpful? Yes No