Answered

Save multiple choices in combo box to sharepoint list

(0) Share

Report

Posted on by zacker

Hi all,

I have two Sharepoint Lists named List1 and List2 respectively and both of types are single line of text. When I created an Edit Form and inserted a combo box in a data card. Then I set the Items property of the combo box as below:

Distinct
(
Filter
(
List1
, Field1 =
Dropdown1_1
.Selected.Value && Field2 =
"specific value"
),Field3)

Then enbaled the multiple selection and set Update property of the data card as below:

ComboBox.SearchText

But when I submit the form, nothing appear in the sharepoint lists.

I have change combo box to drop down control and text input control, both of them can deliver right value to sharepoint list. How can I fix this problem?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-yueyun-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi , @DylanWong

According to your description, you want to save the multiple selected items to the Sharepoint Text column.

Please try to use this code in your DataCard- Update property in your side.

Concat(ComboBox1.SelectedItems ,Value ,",")

ComboBox1 is my Combo box Name , you need to replace it in your side.

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
zacker 60 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-yueyun-msft ,

Thanks for the solution and it works for me! Appreciate it if you could give more explanations on why my code didn't work.

Was this reply helpful? Yes No
v-yueyun-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi , @DylanWong

The Combobox.searchText is return the searching text in Combo box instead of the selected items in your side.

Combo box control in Power Apps - Power Apps | Microsoft Learn

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No