Unanswered

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

I have the same question (0)

All responses (5)

Answers (1)

v-mengmli-msft on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
Prathamesh2415 on at

Like (0)

Report

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

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.

Was this reply helpful? Yes No
v-mengmli-msft on at

Like (0)

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

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

Was this reply helpful? Yes No
Prathamesh2415 on at

Like (0)

Report

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

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.

Was this reply helpful? Yes No
Verified answer

v-mengmli-msft on at

Like (0)

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

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

Was this reply helpful? Yes No