PowerApps Delegation

By -
    Delegation is a very important concept that you have to understand, especially when you will be working with large data sets in PowerApps. First, let’s know that “delegate” means to assign tasks to someone else.(Here power app will delegate data processing to data source)

What is PowerApps Delegation?

    In PowerApps when you are working with the data sources (Dataverse(CDS), SQL, SharePoint, etc…), the data processing tasks are assigned to data sources rather than done by PowerApps itself. This is called PowerApps Delegations.

Delegable Data Sources:

  • Delegable data sources mean the data sources that process data logic in a similar to PowerApps does.
  • Not all the data sources support all the functions of PowerApps.
  • Delegable data sources:
    • Common Data Service (CDS) also called as Dataverse
    • SQL Server
    • SharePont

Delegable functions

  • Not Delegable: When we working with large data some function will not work(not Delegable), it will give you a warning sign

  • Delegable: There are only a few functions that are Delegable(which will work with large data)
  • Work with not Delegable function: You need to bring the data in PowerApps and then use PowerApps functions on the data.
  • Check this Link for Delegable & Non Delegable functions

Limit of Non-Delegable records:

  • The default limit for Non-Delegable record is 500
  • You can extend the default limit to a maximum of 2000 by following instructions.
    • Open your app
    • Go to File Tab >> App settings
    • Click on Advanced Settings.
    • You can set the value: Data row limit for non-delegable queries

Delegations general workarounds:

  • The quickest and Not-Recommended fix: To increase the limit of the Non-Delegable records from the app settings.
  • Use all the possible Delegable functions: This is a kind of POC on what all the Delegable functions you can use in your application.
  • Choose your Data Source wisely: If you have more than 5000 records, I would prefer SQL Server or Common Data Service (CDS) because SharePoint has its own limitation of searching in more than 5000 records, in that case, you might need to index the SharePoint column which is being searched from PowerApps

Please refer this link  Link2 for more details

Comments

Post a Comment

Popular posts from this blog

Upload Single/Multiple file by using the REST API and jQuery SharePoint 2013

By -
Image
Upload  Single/Multiple  file by using the REST API and jQuery SharePoint 2013 Here you can find how to upload single/multiple file in SharePoint 2013 Library using Rest API. We can use the Content Editor web part to call the script files. Include Script files in Content Editor: Go to content editor -> Edit Source -> enter the code like below (code for including the script files) For 'jquery.min.js' we can either use direct link from online or we can download to our SharePoint library & We can use that. <script src=" https://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js" ></script> OR use the below code <script src="/ sites/<SiteName>/<Subsite>/SiteAssets/jquery-1.11.1.min.j s"></script> <script src="/ sites/ <SiteName>/<Subsite> /SiteAssets/taskpage.js " type="text/javascript"></script> <script src=" /sites/ <SiteName>/<Subs
Read more

A type named 'SP.Data. could not be resolved by the model error

By -
Image
When we are trying to update task list we will get this error " A type named 'SP.Data. could not be resolved by the model error. When a model is available, each type name must resolve to a valid name must resolve to a a valid type" This happens because there is a space in the list name. To resolve this issue we need to get the exact list name to be used in "SP.Data" 1.Use the below URL in chrome browser <SiteUrl>/_api/web/lists/GetByTitle('List Name')/ For Example:  https://SiteURL/_api/web/lists/GetByTitle('Workflow Tasks')/ Some times in Chrome browser you may get Authentication error. For that first open the list from your Chrome browser & then use the above URL. 2.Find "SP.Data" -> now you will get the list name that you can be used in SP.Data.ListNameListitem
Read more

Add content type to SharePoint List/Library using REST API

By -
Add content type to SharePoint List/Library using REST API Use this below code to add content type to SharePoint Library using REST API. For this you need to use the content type ID. Below function will get the content type ID from content type name & we will pass the content type id to next function which will update content type to list/library. var   varContentTypeName = " Your Content Type name "; var   Listname = " Your List name where you want to add content type "; //This will get the content type ID from content type Name function  getContentTypeID() { var deferred = $.Deferred();     var  isCurrentUserIsApprover = false ; var  serverURL = _spPageContextInfo.webAbsoluteUrl; var  listURL = String.format(" {0}/_api/web/AvailableContentTypes?$select=Name,Id,StringId&$filter=Name eq '"+varContentTypeName+"' ",serverURL); $.ajax({ url: listURL, type: " GET ", async: false, headers:
Read more