Help with Delegation warning

(0) Share

Report

Posted on by Power_Dude

167

Hi 🙂,

Im wondering if it's possible to do what i'm doing here without a delegation warning.
If its not, I will look into the possibilty of auto cleaning the SPlist before it reach e.g. 1500 rows (settings are set to 2000), and store the data into a new list or something.

What I need to do is to update the status on all rows in gallery to "ForApproval". I will also use the same code for updating new statuses along the way.

My gallery has this code:

Spoiler (Highlight to read)

Filter('Timeregistrering (overtid)'; Ansatt.DisplayName = currentUser.FullName; Status = "Saved")

The code below with underlining is getting delegation warning.
Code:

Spoiler (Highlight to read)

ForAll(Gallery2.AllItems; Patch('Timeregistrering (overtid)'; First(Filter('Timeregistrering (overtid)'; Status="Saved"));
{
Status: "ForApproval";
Tittel: [@Tittel].Text;
Dato: [@Dato].SelectedDate;
Kunde: [@Kunde].Text;
SR: [@SR].Text;
Klokkeslett: [@Klokkeslett].Text;
Total: Totalt.Text;
Arbeid: [@Arbeid].Text;
Ansatt: {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser";
Claims: "i:0#.f|membership|" & currentUser.Email;
Department: "";
DisplayName: currentUser.FullName;
Email: currentUser.Email;
JobTitle: "";
Picture: ""
}
}
)
)

ForAll(Gallery2.AllItems; Patch('Timeregistrering (overtid)'; First(Filter('Timeregistrering (overtid)'; Status="Saved"));{Status: "ForApproval";Tittel: [@Tittel].Text;Dato: [@Dato].SelectedDate;Kunde: [@Kunde].Text;SR: [@SR].Text;Klokkeslett: [@Klokkeslett].Text;Total: Totalt.Text;Arbeid: [@Arbeid].Text;Ansatt: {'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser";Claims: "i:0#.f|membership|" & currentUser.Email;Department: "";DisplayName: currentUser.FullName;Email: currentUser.Email;JobTitle: "";Picture: ""}}))

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Power_Dude

The FIRST function cannot be delegated

First(Filter('Timeregistrering (overtid)'; Status="Saved"))

To remove the warning use LOOKUP instead.

LookUp('Timeregistrering (overtid)'; Status="Saved")

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Power_Dude 167 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mdevaney ,

That worked just perfect. Thanks 🙂

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Power_Dude

LOOKUP also performs better too. Why? LOOKUP stops searching the datasource when it finds the first records whereas FILTER must retrieve the entire datasource and then get the 1st record 🙂

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
PrntScrn 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Actually, it did not work. I did not test it good enough. That will update the status of every user, and also overwrite the records that belongs to the other users. I need to only update the status of current user. Do you perhaps have a solution for that as well?

Was this reply helpful? Yes No
PrntScrn 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Forget it, I added && to the formula.
LookUp('Timeregistrering (overtid)'; Status="Lagret" && Ansatt.DisplayName = currentUser.FullName)

Thanks for the help 😃

Was this reply helpful? Yes No
Power_Dude 167 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry for all the confusion but I am @PrntScrn as well.
I have a couple of users for testing and stuff.

Thanks again 😅

Was this reply helpful? Yes No