Answered

Is delegation possible when patching an existing SharePoint item?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

It seems that when patching an existing SharePoint item, the "First" function (which is non-delagable) is required to identify only one record. Is anyone aware of a delagable method to patch a record? I am trying to scale-up an app that would connect to a SharePoint list that I anticipate could have >10,000 items. Thanks for any help!

Background: I created an app that allows students to write practice questions, practice and rate questions created by other students, earn points for highly-rateq questions they authored and answering questions correctly, etc (see attached for some documentation if interested). It works well for one course, but I was hoping to make it available to the University by adding a course ID.

Student Questions...

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(3)

Report
Copy link

Link copied!

Hi @Anonymous,
You can use Lookup(), Filter(), "= ", and StartsWith() in Sharepoint as these are all delegatable functions and should be sufficient to identify a unique record to Patch. Sharepoint automatically creates a Primary key (ID) for every list and that can be filtered in a Patch() function. The syntax for editing a record is Patch( DataSource, BaseRecord, ChangeRecord1 [, ChangeRecord2, … ]). So for example, a BaseRecord can by found by Lookup(Datasource, ID = Gallery.Selected.ID) without worrying about delegation.
Tip: Remember to index searchable columns in large Sharepoint lists, {I believe that the ID column is automatically indexed).
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, @Drrickryp! I had no idea you could use LookUp within a Patch to identify the record. DMTWD (Dumped my trunks with delight)!!
SJ-15052312-0 418 on at

Like
a
(0)

Report
Copy link

Link copied!

@Drrickryp is delegation necessary for Patch()? If this user didn't include lookup() or filter() would the patch not update the record if it was the 501st record in sharepoint?
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@samuelJ

Patch() requires three elements, a datasource, a record to patch (or a new record indicated by Defaults(), and the field or fields that must be patched. If you don't specify the record being modified, there is no way for PowerApps to identify it.