How To Fix Microsoft Power Apps Delegation Warning

The only warning that every serious PowerApps developer MUST know about

What you'll learn

What delegation is in PowerApps

How delegation can help you for more efficient and faster responding apps

Understanding delegation warning and when you should really care about it

How to enable app testers to evaluate the app functionality related to delegation

Delegable and non-delegable table functions in PowerApps

How to push delegation warning under the rug and update your resume for another job

How to go around delegation limitation using alternative functions or Power Automate

Comparing SharePoint online and Dataverse delegation capabilities

Requirements

Working knowledge of Microsoft Power Apps

Basing knowledge of Power Automate

Basic understanding of SharePoint online and Dataverse

Description

If you have worked with PowerApps and tried connecting your app to any data source (SharePoint, Dataverse, SQL Server or salesforce) you have definitely seen the delegation warning.If you are working with small app with small data behind it, you cam easily disregard it; but when the number of the records go beyond 500, you start seeing some unexpected behavior.In this course you learn about1. What delegation is in PowerApps2. How delegation can help you for more efficient and faster responding apps3. Understanding delegation warning and when you should really care about it4. How to enable app testers to evaluate the app functionality related to delegation5. Delegable and non-delegable table functions in PowerApps6. How to push delegation warning under the rug and update your resume for another job7. How to go around delegation limitation using alternative functions or Power Automate8. Comparing SharePoint online and Dataverse delegation capabilitiesThis is not the beginner course. This is designed for developers that use PowerApps as their primary development platform and design apps that interact with large amount of data in Dataverse or SharePoint.This is not a hands-on course. It is packed with demos and quizzes. It is all about understanding and applying the knowledge to your own solutions. Assumption is that you already know how to build the app in PowerApps. You just need to scale it for larger amount of data to work with.

Overview

Section 1: Introduction

Lecture 1 What is this course about?

Lecture 2 The course roadmap

Section 2: Understanding importance of delegation

Lecture 3 What's delegation and why do we need it?

Lecture 4 What if we completely ignore delegation warning?

Section 3: Delegation matters in these PowerApps table functions

Lecture 5 Data source setup

Lecture 6 Creating the app for this course

Lecture 7 How delegation works with Excel

Lecture 8 Search vs Filter … SharePoint vs Dataverse

Lecture 9 What we learned so far - Important review

Lecture 10 Delegation in PowerApps LookUp function

Lecture 11 Delegation in Choice fields (SharePoint vs Dataverse)

Lecture 12 Lookup field and delegation challenges (Part 1)

Lecture 13 Lookup field and delegation challenges (Part 2)

Lecture 14 Bypass delegation limitation between SharePoint list and combobox

Lecture 15 Delegation and SharePoint person field (Single selection vs Multi selection)

Lecture 16 CountRows and CountIf delegation in Dataverse

Lecture 17 CountRows and CountIf delegation inside SharePoint

Lecture 18 How RemoveIf and UpdateIf handle delegation

Lecture 19 Conclusion

Section 4: When delegation is dead end

Lecture 20 What is this section about

Lecture 21 Be creative to push PowerApps delegation limitations

Lecture 22 Using Power Automate flow to push delegation limits

PowerApps developers who build apps on SharePoint or Dataverse,Developers who build apps with large amount of data