cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Is delegation possible when patching an existing SharePoint item?

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Drrickryp
Super User II
Super User II

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).

View solution in original post

2 REPLIES 2
Drrickryp
Super User II
Super User II

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).

View solution in original post

Anonymous
Not applicable

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

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (2,829)