You’re offline. This is a read only version of the page.
Hi people!
For the last couple of month, I've been running one particular Canvas Apps that's connected to various Dataverse tables with considerable amounts of data (+2,000 rows). It wasn't until today that I realized that I've been relying on the Filter() function for a lot of the galleries in this app. Fortunately, I have not encountered any issues which might not let me filter or see a portion of the data.
I found this article today; Connect to Microsoft Dataverse - Power Apps | Microsoft Learn that I think it is helpful for people trying to learn about delegations. However, I'm struggling to understand if Dataverse behaves differently to other data sources (i.e. SharePoint lists).
All of that said, my main question is really the following: Is Filter() delegable in Dataverse? And if this is the case; which data sources have less delegation than Dataverse?
Thanks for the help in advance!
@mjmedina97, adding to what @Amik mentioned, Dataverse provide Power Fx aware relationships. If you have relationships set between your tables in DV, you don't need to use lookups to retrieve related data for single level relationships. Also, currently in experimental, UpdateIF and RemoveIf are delegable to Dataverse. One more thing, the least DataSource that support delegation and is recognized as DataSource by PowerApps is Excel.
Hi @mjmedina97 ,
You can find the answer to these questions including the different delegable functions for the most common data sources via the link below (see the Delegable Sources heading).
https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/delegation-overview
In short, the Filter function is certainly delegable in Dataverse and based on the above link, the data source with the least number of delegable functions and operations is SharePoint. Note a key benefit of using Dataverse compared to other data sources is the ability to build more advanced filtering using Dataverse Views.
You also have enhanced delegation which includes In function across multiple field types (text, choice, number, datetime etc). This is unique to Dataverse.
------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.
If you like my response, please give it a Thumbs Up.
Imran-Ami Khan
#1
WarrenBelz
637
Most Valuable Professional
#2
stampcoin
570
Super User 2025 Season 2
#3
Power Apps 1919
473
Share
Report
All responses (
Answers (
