Hi @Anonymous ,
Based on the issue that you mentioned, I think there is something wrong with the _PreviousWeek variable that you set within your app.
I have made a test on my side, please consider take a try to modify your formula as below:
Set(_AllChangeItems, Sort('Change Control Calendar', 'Start Time', Descending));
Set(
_PreviousWeek,
Filter(
_AllChangeItems,
Value(Text('Start Time', "[$-en-US]yyyymmdd")) >= Value(Text(DateAdd(Today(),-7,Days), "[$-en-US]yyyymmdd"))
)
);
Navigate(SelectView, ScreenTransition.Fade)
Or
Set(_AllChangeItems, Sort('Change Control Calendar', 'Start Time', Descending));
Set(
_PreviousWeek,
Filter(
_AllChangeItems,
'Start Time' >= DateAdd(Today(), -7, Days)
)
);
Navigate(SelectView, ScreenTransition.Fade)
In addition, you could also consider take a try to use the following formula on the data item source directly (instead of using variable😞
Sort(
Filter(
'Change Control Calendar',
Value(Text('Start Time', "[$-en-US]yyyymmdd")) >= Value(Text(DateAdd(Today(),-7,Days), "[$-en-US]yyyymmdd"))
),
'Start Time',
Descending
)
Please take a try with above solution, check if the issue is solved.
Best regards,
