Power Community

Power Community

Delegation with SharePoint lists Power Apps vs Power Automate

Delegate

We all know about delegation warnings in Power Apps, but how about delegation with SharePoint lists in Power Automate? Ever seen those blue lines in Power Automate?

Delegation with SharePoint lists warnings in Power Apps

In Power Apps there are quite a few delegation warnings that you can get.

Delegation with SharePoint lists in Power Apps

And when we hover over that blue line we will see that the Not function isn’t delegable within Power Apps.

Delegation with SharePoint lists Power Apps vs Power Automate Microsoft Power Automate, Microsoft Power Apps image 21

Looking at the SharePoint connector documentation we quite quickly find out what all the issues are that we might hit when we see those blue lines.

But how about Power Automate.

Delegation in Power Automate

If we try the Get Items action in the experimental UI then we will find that the not equals is not available. Is this because of the delegation issues found within Power Apps? Or is this just one of those pains in Power Automate?

Delegation with SharePoint lists in Power Automate or maybe not

Then of course we have to try this in the non experimental UI as well.

Delegation with SharePoint lists Power Apps vs Power Automate Microsoft Power Automate, Microsoft Power Apps image 23

And when we run this flow it actually just works. I’m getting the result that I’m expecting back.

This is probably also a good moment for a very large warning! If you switch between experimental features on and off then you will break your flows. As the ne is simply replaced by Equals in the experiment UI.

Querying large lists

Now if we create a list with 6000 items ( or any number larger than 5000). Then we will find that querying beyond the 5000 items will simply fail.

This isn’t immediately something to do with delegation. This is just SharePoint stopping us querying beyond 5000 items.

Delegation with SharePoint lists Power Apps vs Power Automate Microsoft Power Automate, Microsoft Power Apps image 24

Checking our SharePoint list settings, we will find that there isn’t an index on the Title column.

Delegation with SharePoint lists Power Apps vs Power Automate Microsoft Power Automate, Microsoft Power Apps image 25

Creating an index on the Title column means that we can query beyond the 5000 items.

And even if we now use an not equals comparison in the OData filter query, we will get the right items back.

Delegation with SharePoint lists Power Apps vs Power Automate Microsoft Power Automate, Microsoft Power Apps image 26

To make the equivalent query work in Power Apps, you would probably have to do something like this:

Delegation with SharePoint lists Power Apps vs Power Automate Microsoft Power Automate, Microsoft Power Apps image 27

Where the Power Apps method is all about avoiding delegation warnings. Power Automate simply seems to work with the SharePoint indexes. This gives us the option to use Power Automate to do the querying instead of avoiding delegation issues in Power Apps

This post was originally published on this site

- Advertisement -spot_img

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisement - Advertisement

Latest News

Is your Asynchronous plugin or Workflow not running in Dataverse?

Implementation Steps: 1. Navigate to https://admin.powerplatform.microsoft.com/ 2. Click on Environments 3. Open the Environment where you want to run your plugins or workflows 4....

More Articles Like This

- Advertisement -spot_img