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

Delegation doesn't work anymore

Since the latest update, delegation doesn't work anymore. Now i get an error saying the operation is prohobited because it exceeds the limit threshhold. 

 

Really? Making updates to make Powerapps worse? It's bad enough you had the 500 limit, now we can't even filter, query 5000+ items even if we bring less than 500 results. 

 

Was this published anywhere?

4 REPLIES 4
Adi2ro
Level: Powered On

Re: Delegation doesn't work anymore

Scratch that, it doesn't work UNLESS you have indexes, which is NOT what the error says, but managed to fix it.

Microsoft Cameron
Microsoft

Re: Delegation doesn't work anymore

Greetings! I see that you were having some trouble with delegation. Can you give us a little more detail about what the PowerApp was doing and what error message you were seeing? If you could provide us with which connectors were involved, what parameters you were passing, the actual text of the error you received, and what indications made you think that delegation was not operating normally... that would be most helpful! If you have been able to solve this, it would be great to know what the issue was and how you solved it - so that we can share your experience with others on the forum. Thanks very much in advance! -Cameron
JRaasumaa
Level 10

Re: Delegation doesn't work anymore


@Cameron wrote:
Greetings! I see that you were having some trouble with delegation. Can you give us a little more detail about what the PowerApp was doing and what error message you were seeing? If you could provide us with which connectors were involved, what parameters you were passing, the actual text of the error you received, and what indications made you think that delegation was not operating normally... that would be most helpful! If you have been able to solve this, it would be great to know what the issue was and how you solved it - so that we can share your experience with others on the forum. Thanks very much in advance! -Cameron

 

I believe his second post is the answer, his tables were not indexed.

Microsoft Cameron
Microsoft

Re: Delegation doesn't work anymore

Yes, I'm simply looking for a bit of detail here so that others might benefit. Were these SQL tables? do you mean to say you added a primary key column (implying an index)? Was it a different connector? For the benefit of the community, if you wouldn't mind just sharing a few details - it would possibly help others who face a similar circumstance. Thanks! -Cameron

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,835)