cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Razes
Regular Visitor

Sharepoint list drop down looses values on edit

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!

1 ACCEPTED SOLUTION

Accepted Solutions
RandyHayes
Super User
Super User

@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.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

View solution in original post

5 REPLIES 5
RandyHayes
Super User
Super User

@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?

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

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

RandyHayes
Super User
Super User

@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.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!
Razes
Regular Visitor

@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
Regular Visitor

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

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (2,124)