Suffering from delegation but no delegation warning

(1) Share

Report

Posted on by milky_bar_may

228

In one of my first apps I have no delegation warning. But yesterday I still had to increase the limit from 500 to 2000.

My source is PowerBi. I then filter out items if a unique code exists in my Sharepoint List.

This is how I have my Gallery Items set up and as I say there is no delegation warning.

Sort(
 Filter(
 PowerBIIntegration.Data,
 'Account' = "112",
 Not(
 'ID' & Text(
 Today(),
 "[$-en-US]dd/mm/yyyy"
 ) in SPList.Column
 
 )
 ),
 'Employee',
 Descending
)

My source is BI Data. I push this data to a list but once the item has been actioned I filter out the item with a unique code ( the Not In part of the formula).

Yesterday, the 501st item was not being filtered out of the gallery. I then had to increase it to 2000 and it filtered out.

What am I doing wrong?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

mdevaney 29,989 Moderator on at

Like (0)

Report

@milky_bar_may

There are 3 functions in your formula that cannot be delegated: NOT, TEXT, IN.

Not(
'ID' & Text(
Today(),
"[$-en-US]dd/mm/yyyy"
) in SPList.Column

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
milky_bar_may 228 on at

Like (0)

Report

Hi @mdevaney ,

I feel like it is groundhog day and every day PowerApps kicks my behind.

From this link Understand delegation in a canvas app it says "Within the Filter and LookUp functions, you can use these with columns of the table to select the appropriate records". In and Not are in the list.

It was my understanding that if I nest the In and Not functions within the filter then this would eliminate the delegation issue.

Can you help me understand where I am wrong?

Thanks as always @mdevaney

Ed

Was this reply helpful? Yes No
Verified answer

mdevaney 29,989 Moderator on at

Like (0)

Report

@milky_bar_may

The delegation documentation by Microsoft is VERY misleading. The functions shown as delegation-friendly are NOT the same for all datasources. SharePoint, SQL and the Common Data Service are all different. However, the article presents those functions as being delegable across all those datasources.

This is kind of a pet peeve of mine about the documentation for PowerApps.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
milky_bar_may 228 on at

Like (0)

Report

Thanks @mdevaney .

I think the answer so is to try and work with collections and your collection workbook.

Many thanks to you again

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

@milky_bar_may

Awesome. If you find the Collections Cookbook useful be sure to give it a Thumbs Up on the app page.

Link to Collections Cookbook:

https://powerusers.microsoft.com/t5/Community-App-Samples/Collections-Cookbook-50-Visual-Examples-amp-Code/td-p/437594

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No