Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Fabian Heil]

?Im currently building a Wiki with different galleries with data coming from SharePoint lists.
I select a gallery item and on the next screen, it shows the next filtered gallery depending on the first selection.
In nearly all sub-galleries i get a delegation warning and dont know why. I read, that the “Filter” formula supports delegation.

Example formulas:

Can someone help me to improve this?

——————————
Fabian Heil
IT Consultant SharePoint Applications
——————————

[Zhi Rui Foo]

Hi Fabian,

If none of your lists will ever exceed 2000 rows, you can ignore the delegation warning safely. The only thing you need to do is set the Data row limit for non-delegable queries to 2000 (File > Setting > Advanced settings).

If any of your lists will likely exceed 2000 rows in their lifetime, you can either (1) use only delegable formulas/functions listed here: https://docs.microsoft.com/en-us/connectors/sharepointonline/ (my guess is your current issue is that “&&” is not delegable, and “=” is not delegable in certain cases such as datetime)

or (2) use the visible property in the flexible height gallery control (it MUST be a flexible height gallery control) to achieve your desired display output. This series of video tutorials will tell you more than I can: https://www.youtube.com/playlist?list=PLTyFh-qDKAiE6ia-D94Qk5-AzpN4dqOmD

Regards,
Zhi Rui

——————————
Zhi Rui Foo
Operations Development Executive
+65 6483 3335
——————————
——————————————-

[Warren Belz]

Hi Fabian,
The ID is the issue – Filters themselves are only delegable if all the components are also delegable.
Two solutions – if you will never have more than 2000 records, collect the data source

ClearCollect(
   colMaterial,
   Maternummern
)?

on all of them and then the filters will work.
Second better long term – add another numeric field to the list and then do a simple SharePoint Designer workflow to set this the ID when a record is created. You could also do this in PowerApps with a ForAll Patch.That field would then be delegable.

——————————
Warren Belz
Rockhampton Qld Australia
+61 409 315 509
——————————
——————————————-