Hi @Alois ,
Well ... the most convenient method would be to set your Items formula to the following but this approach will give you a delegation warning as the Month function cannot be delegated to sharepoint.
Sort(
Filter('Swab Test Calendar_1',
Status.Value="Completed" && Month('Pick Up Time')=Month(Today())
),
'Pick Up Time',
Ascending)
So ...let's try another way:
OnVisible Property of the Screen define 2 context variables used also to avoid delegation warning:
UpdateContext({_firstDayCurrentMonth: Date(Year(Today()),Month(Today()),1)})
UpdateContext({_firstDayNextMonth: Date(Year(Today()),Month(Today())+1,1)})
and the formula will be like:
Sort(
Filter('Swab Test Calendar_1',
Status.Value="Completed" &&
'Pick Up Time'>=_firstDayCurrentMonth &&
'Pick Up Time'<_firstDayNextMonth
),
'Pick Up Time',
Ascending)
Hope it helps !
