Save combo box value to SharePoint list

(1) Share

Report

Posted on by kinghnvn

Hi everyone,

I have two SP Lists:

SP List 1 and SP List 2 - I'm using this list to populate the value to my combo box.

I created a ComboBox1 and a Save button on Power Apps and I wanted to save the selected value to SharePoint list when a user choice within the ComboBox1 and click on the Save button to save.

My problem is the value in my Combo Box1 which is from SP List 2 is not saving in SP List 1.

Hope you can help me on this as I was stuck on this problem.

Thank you.

Categories:

General Questions

All responses (3)

Answers (0)

AmínAA 1,063 Super User 2025 Season 1 on at

Like (0)

Report
Re: Save combo box value to SharePoint list

Hi there @kinghnvn!

After some testing I found out you can do it this way!

Items property on ComboBox
Distinct(LIST2;Country)

OnSelect property on Button
Patch( LIST1; Defaults(LIST1); { Title: "YOUR TITLE COLUMN"; Country: { '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"; Id: LookUp( LIST2; Country = ComboBox1.Selected.Value ).ID; Value: ComboBox1.Selected.Value } } )

PowerApps doesn't seem to like Sharepoints Search columns that much, however I have recreated both lists with the Search column and it does work for me, so hopefully it will work for you as well . . . Bear in mind you will have to add any required columns for this to work, in my case I hade the Title column which was generated by default, and the Country column, both in the LIST1 as a search and in the LIST2 as a text field.

Hopefully this fixes your problems, otherwise, feel free to reply!
kinghnvn on at

Like (0)

Report

Re: Save combo box value to SharePoint list

@AmínAA
Please see the codes below

Thank you.
AmínAA 1,063 Super User 2025 Season 1 on at

Like (0)

Report

Re: Save combo box value to SharePoint list

Greetings!

As it is I am having trouble thinking on what could the problem be . . . Could you share the codes you have on both comboboxes and buttons?