Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

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

(0) ShareShare
ReportReport
Posted on by

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

NameCombobox1Combobx2
name C1value1C2value1
name C1Value1C2Value2
name C1Value2 C2Value1
name C1Value2 C2Value2

 
I am able to get results in this format.

NameCombobox1Combobx2
name C1value1C2value1,C2Value2
name C1Value2 C2Value1,C2Value2

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

Prathamesh2415_0-1697787715901.png

Prathamesh2415_1-1697788595661.png

 

 



  • Verified answer
    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

  • 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,

    Prathamesh2415_0-1697795121900.png

    Which giving result as :

    NameCombobox1Combobx2
    name C1value1C2value1,C2Value2
    name C1Value2 C2Value1,C2Value2


    Desire result is :

    NameCombobox1Combobx2
    name C1value1C2value1
    name C1Value1C2Value2
    name C1Value2 C2Value1
    name C1Value2 C2Value2

     Thank you for your significant time and effort.
    Regards,
    Prathamesh mule.

  • 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

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

    Prathamesh2415_0-1697791587784.png

    Combobox1:

    Prathamesh2415_1-1697791641267.png

    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.

     

  • 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

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard