[PowerApps] Tip #14: How to avoid delegation issues even with SharePoint list data
We'll introduce a series of tips and procedures to help you make better use of Microsoft 365.
We'll answer any questions you may have about how to implement this in PowerApps.
In this video, we'll explain and examine the frequently asked question about delegation (2000 cases) and introduce appropriate, specific methods.
This is the main code used in the video.
*It seems that the smaller version with angle brackets cannot be used in the summary, so please convert it yourself!
==================================================================
OnSelect button to retrieve collection
UpdateContext({threshold: 2000 });
UpdateContext({lastRecord: First(Sort(delegation_test,ID,SortOrder.Descending))});
UpdateContext({LoopCount: RoundUp(lastRecord.ID/threshold,0)});
ForAll(
Sequence(LoopCount, 0),
With(
{
prev: Value * threshold,
next: (Value + 1) * threshold
},
Collect(coldelegation_test, Filter(delegation_test, prev SubID && SubID = next))
)
);
=====================================================================
We deliver content that even beginners can immediately put into practice by following along.
A pseudo-engineer from a non-IT industry or department, certified as an "Applied Information Technology Engineer," delivers work efficiency tips from a hands-on perspective. We aim to post at least once every one to two weeks.
=====================================================================================================
Have you ever experienced a situation where a process you previously performed using VBA suddenly stopped working properly and your operations stalled? Why not migrate that process to PowerPlatform and further automate it?
■Customizations of the flows and apps shown in the video are available for a fee.
We have extensive experience building PowerAutomate flows, PowerApps apps (campus), and SharePoint sites, both internally and externally, primarily for Microsoft 365.
▼I recently started learning, but even after watching this video, I can't customize it properly in my environment. ▼I've been tasked with digital transformation within my internal (departmental) processes, but I don't know where to start. I have no idea how to apply it to my own work. ▼I'd like to hold a study group to revitalize digital transformation within my department. If you're in this situation, please contact us via the form below. Even if you just want to learn, we're happy to help!
See the channel description for contact information.
Subscribe here
/ @power_platform
Music & Sound Effects
Amacha Music Studio
https://amachamusic.chagasi.com/
Sound Effects Lab
https://soundeffect-lab.info/
[Credits]
VOICEVOX: Takehiro Kurono
Character Illustration: moiky