Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Patch Function for ComboBox for Custom List in sharepoint

(0) ShareShare
ReportReport
Posted on by

Hello Everyone,

I'm new to PowerApps, and I have a form that is linked to Sharepoint List.

After filling out the Required fields on submission of form, the value is shared in Sharepoint using the patch function.

However, there are some values in the dropdown that must be chosen, and since I like to pick many values, I'm using combobox.

I'm having trouble patching the value selected in combobox, because I need to store the selected data in Sharepoint List text format.
I want to select multiple values in comboBox , and after submitting the form, the data should be stored in the SharePoint List Country column.


1. Value of ComboBox coming from Custom List.
     

Distinct(Country.Title,Title)


2. Sharepoint List in which Patch mapped. 

Prathamesh2415_1-1692715738139.png


3.Country Field in List as Text

 

4. Patch activity 
 

Prathamesh2415_3-1692716573198.png


i tried Text(ComboBox1.SelectedText.Value).

THE Function Text has some invalid arguments.

 

Categories:
  • Verified answer
    LaurensM Profile Picture
    LaurensM 12,510 on at
    Re: Patch Function for ComboBox for Custom List in sharepoint

    Hi @Prathamesh2415,

     

    If they can select multiple values, you can use Concat to concatenate the values with a separator:

     

    Concat(ComboBox1.SelectedItems, Value, ", ")

     

    If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

    Thanks!

     

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

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard