Unanswered

Dropdowns in forms are displaying values - I want the label to display instead

(1) Share

Report

Posted on by kristinegriba

151

I have a an app I have built in PowerApps, and I have a form that uses dropdowns... whenever the form is in New mode, I have this problem (see embedded image below):

The data source for the table is a Dataverse table called BTS_Users

Referring to the table's columns demonstrating this issue are called, BookMode, ConsulMode, and CorpMode, and they are each synced with the choice ModeChoice.

ModeChoice contains the following options: n/a, Submitter, Reviewer.

Below are two more screen captures providing additional information regarding these dropdowns.

In this image above, if I selected anything other than 'None' for Views, the dropdowns display correctly; unfortunately, the form will then NOT submit. So it's like I have to set Views to 'None.'

In this image above, if I select a specific dropdown to inspect it, both 'Primary text' and 'SearchField' only have the option for 'Value' and not 'Label'

Also, what seems weird to me, is that now 'Data source' is showing as 'None'

When I click on 'Depends on..." I get the message that the control is locked.

Anyone have a solution or something for me to try?

Thanks in advance for taking the time to read my post/query.

Kristine

Categories:

General Questions

I have the same question (0)

All responses (2)

Answers (0)

sannavajjala87 47 on at

Like (0)

Report

Dropdowns in forms are displaying values - I want the label to display instead

Hi Kristine,

that 525490000 value is the numeric value of the Dataverse choice, which is being used as the default instead of the actual choice record. You can fix it by unlocking the data cards and wiring the combo boxes manually:

1. Unlock the card

Select BookMode data card → Advanced pane → click Unlock.

2. Set the combo’s key properties (same pattern for BookMode / ConsulMode / CorpMode):

Items of the combo box:

Choices([@BTS_Users].BookMode)

DefaultSelectedItems:

If(

Form1.Mode = FormMode.New,

Blank(),

Parent.Default

)

(This prevents the raw numeric value showing in New mode.)

Data card Update:

DataCardValue_BookMode.Selected

3. Leave the form’s Views property as None

Using a specific Dataverse view there can make the form behave like it’s read-only and block submit.

Also, seeing only Value for Primary text and SearchField is normal for Dataverse choices – Value is the label in this case.

After wiring the cards like this, the dropdowns should show n/a, Submitter, Reviewer correctly in New mode and the form should submit without errors.

1 people found this reply helpful.

Was this reply helpful? Yes No
kristinegriba 151 on at

Like (0)

Report

Dropdowns in forms are displaying values - I want the label to display instead

@sannavajjala87 thanks for your reply! I did manage to figure out my problem yesterday, but I still wanted to see what people may reply with with.

My solution: for the columns that were choice columns in my Dataverse table, I set the default to none, and that solved the issue beautifully. Not sure why, but it worked perfectly.

Thank you again!

Was this reply helpful? Yes No