cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
DDCJOEE
Level: Powered On

Working around lack of Salesforce delegation

I am trying to work with the Salesforce data connector, but finding the lack of delegation support to be a roadblock. My data is often incomplete and loading it takes upwards of two minutes. Does anyone have a workaround for this or know of a best practice for efficiently loading data from Salesforce into PowerApps?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Working around lack of Salesforce delegation

Hi @DDCJOEE ,

The reason why you met this problem is that Salesforce is non-delagateable data source in PowerApps.

Delegation is powerapps itself limit.

PowerApps could only deal with data at most 2000 in local.

If your record is smaller than 2000, you just need to change the non-delegateable limit to 2000.

delegation.jpg

 

Then delegation warning will not make the app not perform well.

If your record is larger than 2000, to deal with delegation problem, I could only suggest you two ways:

1)use delegateable data source and delegateable functions.

For now, only three data sources are delegateable in PowerApps:

You could click it to see its delegateable functions.

2) save your data to collection and deal with these data in collection.

In collection, PowerApps doesn't have delegation limit.

 

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Working around lack of Salesforce delegation

Hi @DDCJOEE ,

The reason why you met this problem is that Salesforce is non-delagateable data source in PowerApps.

Delegation is powerapps itself limit.

PowerApps could only deal with data at most 2000 in local.

If your record is smaller than 2000, you just need to change the non-delegateable limit to 2000.

delegation.jpg

 

Then delegation warning will not make the app not perform well.

If your record is larger than 2000, to deal with delegation problem, I could only suggest you two ways:

1)use delegateable data source and delegateable functions.

For now, only three data sources are delegateable in PowerApps:

You could click it to see its delegateable functions.

2) save your data to collection and deal with these data in collection.

In collection, PowerApps doesn't have delegation limit.

 

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

DDCJOEE
Level: Powered On

Re: Working around lack of Salesforce delegation

If this is the case, then the documentation is incorrect. 

https://docs.microsoft.com/en-us/connectors/salesforce/#top-level-functions

The documentation currently states the following:

PowerApps delegable functions and operations for Salesforce

These PowerApps operations, for a given data type, may be delegated to Salesforce for processing (rather than processing locally within PowerApps). 

  Delegable

AverageNo
FilterYes
LookUpYes
MaxNo
MinNo
SearchYes
SortYes
SortByColumnsYes
SumNo

 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,786)