web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Patch Combo Box Select...
Power Apps
Unanswered

Patch Combo Box Selected Items in SharePointList

(0) ShareShare
ReportReport
Posted on by 195

Hello Everyone,

 

Good day!

 

Newbie here. I have a SharePoint List named Vendor and a Collection created in power apps for the combo box selected items.

I was trying to patch but I got error. 

 

I tried Patch(datasource, colSelectedVendors);   and the other one I tried is 

ForAll(

             VendorSelectionBox.SelectedItems,
             Patch(
                        datasource,
                        Defaults(datasource),
                        {
                               Request: {
                                       Id: gvRequestID,
                               },

                               Vendor: {
                                       Value: Title
                               }
                        }
           )
)

 


Please refer to image below..

 

Thanks in advance. 

 

YamiteKudasai_0-1629977613290.png

 

Categories:
I have the same question (0)
  • PowerSäm Profile Picture
    775 on at

    Hi @YamiteKudasai ,

     

    Are the 120 and E&Y HCL the contents of the combo boxes?

     

    Try this:

     

    Patch(yourDatasource,

              Default(yourDatasource),

              Request: Comboboxname.Selected.Value,

              Vendor: Comboboxname.Selected.Value)

     

     

    The name in the patch function must be identical to the column name in sharepoint

  • zmansuri Profile Picture
    6,048 Super User 2024 Season 1 on at

    Schema of the collection and schema of your database should match. To patch the whole collection.

    ClearCollect(
    colTest,
    ShowColumns(
    Table(Defaults(ListName)),
    "ColumnName"
    )
    )

    This will create a collection with the same schema. then you can patch it

    Patch(ListName,Defaults(ListName),colTest)

  • YamiteKudasai Profile Picture
    195 on at

    Request is a number only but my error is 

    YamiteKudasai_0-1629980674926.png

     

  • zmansuri Profile Picture
    6,048 Super User 2024 Season 1 on at

    getRequestId variable is whole record. your sharepoint list expect just a number

  • YamiteKudasai Profile Picture
    195 on at

    my gvRequestID contains only number  like 1234. I initialize is at Set(gvRequestID, 1234)

  • WarrenBelz Profile Picture
    152,867 Most Valuable Professional on at

    @YamiteKudasai ,

    Please look at your SharePoint field definition - I strongly suspect Request is a Lookup column.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 759 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 310 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 228

Last 30 days Overall leaderboard