You’re offline. This is a read only version of the page.
12
Hey all,
i am currently working on an App for worktime tracking. I want to make the employees visible how many hours per day and per week they already tracked within the app and whats their daily ammount of work. Every item will be added to a SharePoint List. I'am currently using the code below to filter the whole list (many Items) by the User who created the item and if the item was created today. I also use sum function to sum all calculated working times up. Now i am facing the problem that "IsToday" and "Sum" function seems not to be delegatable. Since the data set will get in one year approx 10.000 items my code will not work.
i will apreciate greatly any help on this.
Thanks
Share
ReportRound(Sum(Filter(Zeiterfassung_V2; Erstellkonto=UserEmail && IsToday(Arbeitsbeginn));Arbeitszeit_berechnet);2) & " von " & Tagesarbeitszeit & " Stunden"
Hi @Woody1 ,
= Today() is Delegable, so if you "pre-filter" the query, providing the output of this is under you limit, you can do the rest
All responses (
Answers (
With(
{
wList:
Filter(
Zeiterfassung_V2;
Erstellkonto = UserEmail &&
Arbeitsbeginn = Today()
)
};
Round(
Sum(
wList,
Arbeitszeit_berechnet
);
2
)
) & " von " & Tagesarbeitszeit & " Stunden"
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Visit my blog Practical Power Apps
