Issue with Dropdown in Modern Form in PowerApps - It's not matching the value with the options

(1) Share

Report

Posted on by bajiomeke

Hi everyone,

I'm facing an issue in my PowerApps app when using a modern form with a dropdown. Here's the situation:

I have a SharePoint list called Customers.
In my app, I'm using a modern form that includes a modern dropdown.
In the Customers list, there's a field called Condicao_Representante. This field is a text field and not a choice field, as the options are stored in another data source.
In the app's form, I replaced the text field Condicao_Representante with a dropdown, and I set the selection options in the Items property of the dropdown from another source.

The issue is: when I try to edit a record, the dropdown doesn't select the corresponding option. If I do the same thing in the old (classic) forms, it works perfectly!

Does anyone know how to solve this issue in the modern form?

Thanks!

Options above comes from a base called Base_Valores_Campos:

This is the Customer database, with a record

I added a textbox and putting "ThisItem.Condicao_Representante" and it is bringing the text right from the Customer database. But on the Dropbox it's not matching with a option!!!!

Should a put something on DefaultSelectedItems in this dropbox? Currently it's empty and I tried somethings but it didn't work.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Suggested answer

Nandit 1,568 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi bajiomeke,

Yes, that's correct. You will have to write a formula to get the text from Customer database. For this to work right the names of the values in the Customer database Condicao_Representante column and Valor_1 column in Base_Valores_Campos should be exactly same.

Try this:

LookUp( Base_Valores_Campos, Valor_1 = ThisItem.Condicao_Representante )

This should work.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!
bajiomeke 53 on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @Nindit,

So, I tried this, but it does not work! It works only on Old Dropdown box.

So, I tried to put brackets [ ] on this LookUp (and change other things to ajust), at the first time it worked, matching and showing the value of the register, BUT, if I click on dropbox it gets an error:
bajiomeke 53 on at

Like
a
(1)

Report
Copy link

Link copied!

One way to work around this problem I found is to make the field on List as Choice (with just 1 value), than I copy this Choice to a Collection, then I clean this Collection and put my values, I think this copy a invisible property.. It works, but it shows a duplicated value.

But, this is a big bug on this control, How can we report it to Microsoft?

It work:

But when you click to list, a value is duplicated. If you select anothe value there, the duplicated value disapear. lol

This way may work for now, even if it duplicates, but would be great if they fix it (or find a way to remove this duplicated)
Verified answer

bajiomeke 53 on at

Like
a
(5)

Report
Copy link

Link copied!

Hi Everyone!

I finally found a solutions to work around this bug!

On the dropdown field, on DefaultSelectedItems I wrote this?

This makes select the option correctly and not duplicate it

But seriously.. Microsoft have to fix it if they want to make PowerApps easy to use.