Answered

Dataverse Delegations: Filter() Function

(0) Share

Report

Posted on by mjmedina97

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!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
AhmedSalih 6,680 Moderator on at

Like (3)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No