Answered

Combobox multiple selected value store separately as single row in sharepoint view using patch activity

(0) Share

Report

Posted on by Prathamesh2415

Hello Everyone,

I am beginner in PowerApps and would appreciate your assistance in resolving this issue.

I've got two comboBoxes. I am choosing multiple information from both comboboxes and saving it in SharePointList. I wanted the outcome of selecting two values from a combobox to be stored separate row with the associated values, for example, if I had a field name and two comboboxes.
Required Result -:

Name	Combobox1	Combobx2
name	C1value1	C2value1
name	C1Value1	C2Value2
name	C1Value2	C2Value1
name	C1Value2	C2Value2

I am able to get results in this format.

Name	Combobox1	Combobx2
name	C1value1	C2value1,C2Value2
name	C1Value2	C2Value1,C2Value2

Can you please help anyone the Combobox selected value we are storing as text in SharePointList

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Prathamesh2415 ,

Could you show me the items of combo box?
And I hope you can use choices of two combo boxes as an example to tell me the results you want to get.

Best regards,
Rimmon Li
Prathamesh2415 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @v-mengmli-msft
I am getting Combobox from Sperate Excel file Name as Country. saving it as Customize columns in Sharepoint as Text.

Combobox1:
Q :And I hope you can use choices of two combo boxes as an example to tell me the results you want to get.
We are now intended to save the value in Text, but if we can get the desired result in Choice, we may consider it. However, it is preferable to obtain value in text.

Thank you for your significant time and effort.
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Prathamesh2415 ,

Please try this:
ForAll(ComboBox1.SelectedItems As C,Patch(List,Defaults(List),{Title:"Hr",abc:Name.Text,Country:C.Country,System:Concat(ComboBox2.SelectedItems,SYSTEM,",")}))

Best regards,
Rimmon Li
Prathamesh2415 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @v-mengmli-msft
As you can see i am already using same code,
Which giving result as :
Name Combobox1 Combobx2
name C1value1 C2value1,C2Value2
name C1Value2 C2Value1,C2Value2

Desire result is :

Name Combobox1 Combobx2
name C1value1 C2value1
name C1Value1 C2Value2
name C1Value2 C2Value1
name C1Value2 C2Value2
Thank you for your significant time and effort.
Regards,
Prathamesh mule.
Verified answer

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Prathamesh2415 ,

Please try this:
ForAll(ComboBox1.SelectedItems As C,ForAll(ComboBox2.SelectedItems As B,Patch(List,Defaults(List),{Title:"Hr",abc:Name.Text,Country:C.Country,System:B.SYSTEM})))

Best regards,
Rimmon Li