Power Platform Community Forum Thread Details

Good morning,

I have a problem with time days and shifts in job. In my task a have to make special timer for shift working. Day in factory lasts from 6:00 AM to 5:59 AM ( Next day) and its diffrent to normal time measuring from 00:00 AM to 11:59PM

1 shift - 6:00 AM -2:00 PM (today)

2 shift 2:00 PM -10:00 PM (today)

3 shift 10:00 PM (today) - 6:00 AM (next day) ( so one shift is on two days)

Now I assign shift based on timer function like this

If(
(Hour(Now())<14)&&((Hour(Now())>=6));"Z1";
(Hour(Now())<22)&&((Hour(Now())>=14));"Z2";
(Hour(Now())<6)&&((Hour(Now())>=00));"Z3+";
(Hour(Now())<=23)&&((Hour(Now())>=22));"Z3"
)

So for to 1 shift I assign "Z1", for shift 2 "Z2" and problem is with sort of gallery in case of night shift because I want to show events only for shift that is now. In Power platform I can sort by days etc. For nihgt shift I assign two markers based on current time Z3+ and Z3

My question is how to properly assign markers to sort galery to show only one shift in this case ? I will answer your questions if you want to know more.

Categories:

Building Power Apps