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
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
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.
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
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.
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