Error on server: number of concurrent requests exceeded the limit of 52

(0) Share

Report

Posted on by werner1

Hi all,

Anyone has any ideas on how to avoid this error message?
I have tried to separate the "Collect" function into multiple steps (StartsWith "1", StartsWith "2" ...) which helped, but in some cases I still get the error.

I've seen the error originate from the different LookUp parts of the AddColumns of this code. Invitations, MQC_Review and MQC_Consultations are all CDS entities.

ClearCollect(
 colPreLoadClientInvit,
 AddColumns(
 Filter(
 colPreLoadClient,
 StartsWith(Client_Number, "1")),
 "InvitationSent",
 LookUp(
 Invitations,
 adx_inviteContact.cr111_client_number = Client_Number,
 'Created On'
 ),
 "ReviewCreatedOn",
 LookUp(
 MQC_Reviews,
 cr111_client_code = Client_Number,
 createdon
 ),
 "ConsultationStatus",
 LookUp(
 'MQC Consultations',
 cr111_clientcode = Client_Number,
 cr111_consultationstatus
 )
 )
);

Any help is appreciated.

Categories:

Building Power Apps

I have the same question (0)