Answered

Sharepoint list drop down looses values on edit

(0) Share

Report

Posted on by Razes

Hi all,

i have built a Products list on Sharepoint which contains dropdown multichoice column Country(lookup to another list called Locations). I used PowerApps to customize that column Country so it can take disctinct values of countries from Locations list and save it to Products list when selected via drop down.

Saving when creating new record works fine. But when i edit the record and change some other attribute and click save, previously selected values in column Country dissapear.

On the Update event on my data card i use the following logic:

ForAll(DataCardValue4.SelectedItems,
 {
 Id: LookUp(Locations, Country=Result,ID),
 Value: DataCardValue4.Selected.Result
 }
)

Any ideas what might be the issue?

Thanks a lot!

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Razes

To be clear, you do not have a dropdown control, you are working with a combobox control.

The DefaultSelectedItems (DSI) property of the control dictates what the combobox shows as selected.

So, what is your DSI property formula as well as the Items property formula?
Razes 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RandyHayes , yes you are right about combo box. The DSI property says "Parent.Default" and Items property is "Distinct([@Locations],Country)"
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Razes

So, for items to be selected in a Combobox, the DSI property must contain records that match the schema of the Items property.

Currently, your Items property is providing records with a Result column.

Your DSI is providing records with an Id and Value column.

These will *never* match!!

You need to reverse the process you had for the update in order to get matching records.

So your DSI would become:

RenameColumns(ThisItem.Country.Value, "Value", "Result")

This will take the table of records with Id and Value and convert it to a single column table as well as rename the column from Value to Result.

This will then match the Items property records.
Razes 8 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes , this works! Thanks

P.S.
For some reason it wont save specific values to list when selected. For ex, every time i select AT or DE it wont be saved, but other countries work fine. Any ideas what would cause that?
Razes 8 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes nevermind the PS part, i found the problem and solved it. Thanks again!