Patch and Update existing SharePoint List from Collection

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a collection that stores the following data: ProjectID, ControlID, Description.

I patch the data to the sharepoint list named "Project to Control" by the following code:

ForAll('collection' As _item,

Patch('Project to Control',

{ProjectID: _item.ProjectID,

ControlD: _item.ControlID,

Description: _item.Description}

)

Assume there are some existing data in the SharePoint list, how can I update the existing SharePoint list from the collection if the record has the same ProjectID & ControlID and create a new record to the SP list for the rest?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

WarrenBelz 155,940 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Try this format

Patch( 'Project to Control', ForAll( 'collection' As _item, With( { wID, Lookup( 'Project to Control', ProjectID = _item.ProjectID && ControlID = _item.ControlID ).ID }, If( IsBlank(wID), { ProjectID: _item.ProjectID, ControlD: _item.ControlID, Description: _item.Description }, { ID: _item.ID, ProjectID: _item.ProjectID, ControlD: _item.ControlID, Description: _item.Description } ) ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
WarrenBelz 155,940 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

It works! Thank you so much for your help! @WarrenBelz

Was this reply helpful? Yes No