Unanswered

Delegation Warning on Max Operation is not Supported by this Connector

(0) Share

Report

Posted on by rifaldyt

Hi all.. i'm newbie with Power Apps. My code is working correctly. But, there was "Delegation warning the highlighted part of this formula might not work correctly. The "Max" operation is not supported by this connector.". Can you solving this. Thanks!

If(

Form2.Valid, SubmitForm(Form2);

Set(

LastTicket, Max('DLFA - Ticketing', Value(Mid('Nomor Tiket', 3, Len('Nomor Tiket') - 2)))

);

Set(NewTicketNumber, If(IsBlank(LastTicket) || LastTicket = 0, 1, LastTicket + 1));

Set(CustomTicketNumber, Concatenate("T-", Text(NewTicketNumber, "[$-en-US]0000")));

Set(

RecordToUpdate, LookUp('DLFA - Ticketing', ID = Form2.LastSubmit.ID)

);

Patch(

'DLFA - Ticketing', RecordToUpdate,

{

'Nomor Tiket': CustomTicketNumber

}

);

ResetForm(Form2);

Set(varShowPopUp, true);

Refresh('DLFA - Ticketing')

)

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
hey @rifaldyt

can you try this:

If( Form2.Valid, SubmitForm(Form2); ClearCollect( TopTickets, FirstN( Sort('DLFA - Ticketing', Value(Mid('Nomor Tiket', 3, Len('Nomor Tiket') - 2)), Descending), 2000 // Adjust this number based on your dataset size and performance considerations ) ); Set( LastTicket, Max(TopTickets, Value(Mid('Nomor Tiket', 3, Len('Nomor Tiket') - 2))) ); Set(NewTicketNumber, If(IsBlank(LastTicket) || LastTicket = 0, 1, LastTicket + 1)); Set(CustomTicketNumber, Concatenate("T-", Text(NewTicketNumber, "[$-en-US]0000"))); // Step 4: Update the record Set( RecordToUpdate, LookUp('DLFA - Ticketing', ID = Form2.LastSubmit.ID) ); Patch( 'DLFA - Ticketing', RecordToUpdate, { 'Nomor Tiket': CustomTicketNumber } ); ResetForm(Form2); Set(varShowPopUp, true); Refresh('DLFA - Ticketing') )

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings
rifaldyt 6 on at

Like
a
(0)

Report
Copy link

Link copied!

thank u @mmbr1606 for ur fast answer. But this code has error on Short function 😞
mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

which error do u recieve?
rifaldyt 6 on at

Like
a
(0)

Report
Copy link

Link copied!

sorry for late reply. i capture the error on image below