Answered

Store Listbox value to SharePoint list

(0) Share

Report

Posted on by nakama

Dear all,

I hope you are doing well. I am new in Powerapps. I am starting with a new canvas up with some questions and store this data in the SharePoint list using patch function.

Everything is ok with me when I utilize the radio button or dropdown, but I have an issue when I want to store the data form Listbox or Combobox with multi-value.

Could you please support me.

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

KrishnaV 5,023 on at

Like (1)

Report
Copy link

Link copied!
Hi @nakama ,

try this:
Patch(SPList,Defaults(SPList),{columnName:contact(Combobox.SelectedItems,Value&",")})
Note: Replace the value with result/column name of the column name you associated with Combobox

combo / multi select works a little different in Power Apps.

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
nakama 23 on at

Like (0)

Report
Copy link

Link copied!
Thanks for the quick response and support, it's working fine. Could you please enhance the below formula:
Test:Concat(ComboBox1.SelectedItems,Value&",")
I got a result like this: 1,2,3,
Can I remove the last ',' to result in 1,2,3

Thanks

Was this reply helpful? Yes No
Verified answer

KrishnaV 5,023 on at

Like (3)

Report
Copy link

Link copied!
Hi @nakama ,

Here it is :
Left(Concat(ComboBox1.SelectedItems,Value&","),Len(Concat(ComboBox1.SelectedItems,Value&","))-1)

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No