cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Does Delegation affect writing on SP list?

Or does it affect only reading rows/columns without any problem during the creation of new rows?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User II
Super User II

Re: Does Delegation affect writing on SP list?

Hi!

 

Delegation should only affect reading, not writing, unless you are trying to write to more records than the delegable limit (and your method of reading the records is non-delegable).

 

Generally speaking:
When you are patching a new item, you patch a single record, regardless of database size, so no issues there.

When you are editing an item, you are doing a LookUp against a single entry, and LookUp is delegable.

 

The problem would come in if you have more than 2k records and you tried to do a ForAll which would then stop at your delegable limit (also please don't ever do this, there is always a better way!)

 

Is there a particular issue you are facing when patching new items or was this a generic question?

 

Thanks,

Sancho

 


@iAm_ManCat

Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you!


Thanks!
You and everyone else in the community make it the awesome and welcoming place it is, keep your questions coming and make sure to 'like' anything that makes you 'Appy
Sancho Harker, MVP


View solution in original post

2 REPLIES 2
Highlighted
Super User II
Super User II

Re: Does Delegation affect writing on SP list?

Hi!

 

Delegation should only affect reading, not writing, unless you are trying to write to more records than the delegable limit (and your method of reading the records is non-delegable).

 

Generally speaking:
When you are patching a new item, you patch a single record, regardless of database size, so no issues there.

When you are editing an item, you are doing a LookUp against a single entry, and LookUp is delegable.

 

The problem would come in if you have more than 2k records and you tried to do a ForAll which would then stop at your delegable limit (also please don't ever do this, there is always a better way!)

 

Is there a particular issue you are facing when patching new items or was this a generic question?

 

Thanks,

Sancho

 


@iAm_ManCat

Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you!


Thanks!
You and everyone else in the community make it the awesome and welcoming place it is, keep your questions coming and make sure to 'like' anything that makes you 'Appy
Sancho Harker, MVP


View solution in original post

Highlighted
Frequent Visitor

Re: Does Delegation affect writing on SP list?

 I think you replied to my question: I'm not facing any trouble, but I have to be sure that I can add how many rows I want to a list which contains data used only for statistics, and not to be reprocessed or re-read by my app

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Come join us today! Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (3,570)