Unanswered

Dropdown in New and Edit Form does not save values in sharepoint list

(0) Share

Report

Posted on by MicaBassi

Hi, I'm a relatively new user of PowerApps so maybe this is an easy fix but I haven't been able to find the issue so far.

In power apps I have two screens with a form each. One screen has the form in New mode, to add new records onto a sharepoint list. The other one has a form in Edit mode, to edit records from that same sharepoint list. In both forms, I have a dropdown that is multiple selection and is searchable.

In Add form:
- I am able to open the "Customers" dropdown and select a value, but when I submit the form, the record is created without the value that I choose for "Customers" (The column "Customers" on the sharepoint list is left empty)
In Edit form:
- I am able to see the value that already exists on the "Customers" column (added manually to the sharepoint list), I am able to open the dropdown and make changes to the selection, but when I submit the form, any value form the column is removed, and my new selection is not saved either.

This is the Items property for the "Customers" dropdown: Distinct(Choices([@MyDataSource].Customers),Value). Also, for the Edit form, I have the following "DefaultSelectedItems" for the dropdown: ThisItem.Customers

I have other dropdowns that work just fine, the only difference between those and this one, is that in this one I have a Distinct on the Items property. I believe that could be causing the issue, since the dropdown seems to work just fine when I remove the distinct and just leave Choices([@MyDataSource].Customers). The reason why I have a Distinct there is because there are some duplicate values, but I don't want them to be displayed more than once within the dropdown list.

I hope someone can help!

Thanks 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report

Hi @MicaBassi ,

I assume this is a Lookup column ? When you use Distinct() and the Value, you loose the Id column reference, so cannot write back the proper content. Firstly, please confirm this column type and also if so, the name of the list and field it is looking up.

Was this reply helpful? Yes No
MicaBassi on at

Like (0)

Report

Hi Warren, yes, it is a Lookup column, forgot to mention that. It is looking on another list named CustomerDetails, column CustomerName. Thanks!

Was this reply helpful? Yes No
WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report
Hi @MicaBassi ,

If you are new to Power Apps, you might ask yourself why you are using Lookup columns at all - I do not and probably never will - but that is another discussion.
As I mentioned, you need to “get back” the Id column which is actually the ID of the record in the second list being looked up. The Data Card Update

ForAll( ComboBoxName.SelectedItems As _Data, { Value: _Data.Value, Id: LookUp( CustomerDetails, CustomerName = _Data.Value ).ID } )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No