Share
Report
147Good evening everyone,
Unfortunately I have to ask again:
I really can't get any further...
I created a “collection” that lists every day of the current month:
Collect(col_Auswahl_AuswerteMIT;tbl_Zeiterfassung_Daily;Filter(tbl_Zeiterfassung_Daily;Name = 'drp_Zeiterfassung-SwahlMIT_2'.Selected.Name);
With({targetMonth: Month(Now()); targetYear: Year(Now())};
With({startDate: Date(targetYear; targetMonth; 1);
endDate: DateAdd(DateAdd(Date(targetYear; targetMonth; 1); 1; TimeUnit.Months); -1; TimeUnit.Days)
};
ForAll(
Sequence(DateDiff(startDate; endDate; TimeUnit.Days)+1);
Date(targetYear; targetMonth; Value)
)
)
)
);;
I also have a Sharepoint Gallery, tbl_Zeiterfassung_daily, where people log in “daily”.
The goal is to create a list of each day
Now I would like to list every single day in the gallery: (A comparison of the two lists, or a collection and the associated Sharepoint list)
Gallery:
Value: Name: StartWork: EndWork:
01/09/2023 Lars
02/09/2023 Larsi 02/09/2023 08:21 02/09/2023 11:45
03/09/2023 Larsi2 empty empty
04/09/2023 Larsi3 04/09/2023 08:11 04/09/2023 12:21
05/09/2023 Larsi4 empty empty
06/09/2023 Larsi5 ... ...
07/09/2023 ...
etc.
All responses (
Answers (
