Patch Combo Box Selected Items in SharePointList

(0) Share

Report

Posted on by YamiteKudasai

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

PowerSäm 775 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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)

Was this reply helpful? Yes No
YamiteKudasai 195 on at

Like (0)

Report
Copy link

Link copied!

Request is a number only but my error is

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
YamiteKudasai 195 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
WarrenBelz 154,411 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@YamiteKudasai ,

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

Was this reply helpful? Yes No