207
I have a collection called "colUserDetails" with columns called "Name", "UserID", "EmailAddress", "Floor", "Zone" & "SeatNumber". The collection will only ever have 1 row.
I then have an SP List called "Monitor App" with the same columns as the collection. All columns are "Single line of Text" type.
I need to patch the data in the collection to the SP list. I have watched so many videos and read so many web pages, but still I cant get it to patch. Please help.
Thanks, in advance.
Hi @StuartSmith,
If Your Collection have the same schema as your SP List it should be easy as
Share
Report
All responses (
Answers (
Patch('Monitor App',colUserDetails)
Just keep in mind columns in SP List need to have same name as collection columns to use above approach
If you looking to Patch only Selected columns it will look like this and then columns can have some name variations you will match columns in Patch as Below
Patch('Monitor App',
ForAll(colUserDetails As _items,
{
ID: _items.ID
Name: _items.Name
UserID: _items.UserID
}
)
)
Hope that Help
Regards
Figured it out, the issue with the SP wanted a "Title" value for the patch, despite removing the "Title" column from the list. Anyway, added "Title: "Blah" and the patch worked.
Patch('Monitor App', Defaults('Monitor App'),
{
Name: First(colUserDetails).Name,
UserID: First(colUserDetails).UserID,
Floor: First(colUserDetails).Floor,
Zone: First(colUserDetails).Zone,
SeatNumber: First(colUserDetails).SeatNumber,
EmailAddress:First(colUserDetails).EmailAddress})
___________________________________________________________________________________
If I have answered your question, please mark your post as Solved
If you like my response, please give it a Thumbs Up
#1
WarrenBelz
146,708
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,030
Most Valuable Professional
