Unanswered

Patch SP List from Collection

(0) Share

Report

Posted on by StuartSmith

225

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

martijnA 62 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

StuartSmith 225 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
SebS 4,582 Moderator on at

Like (0)

Report
Hi @StuartSmith,

If Your Collection have the same schema as your SP List it should be easy as

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

Was this reply helpful? Yes No