Answered

Creating a set Rota in powerapp

(0) Share

Report

Posted on by HiteshM

I have created a basis of holiday booking system for my team and the management to use. Currently the calendar populates with the data i have .

Which is stored in a SP List called Leave Requests ,

Each day shows how many people are off that day and once you click on the day its show who is off in another gallery.

My problem is i and the management would like to display the Rota on the calendar too. Its a 4 on 4 off 8 day cycle. I have tried to create a collection but keep getting behaviour issues. Also wish this rota to be created yearly in advance automatically . Looking at the picture below first day in would 5th September

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (2)

Sort by

Mike2500 1,247 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
I'm not exactly sure what you're trying to do with ROTA. Have a field in the the table that indicates if the day is part of the on or off, based on the 4 day on and 4 day off cycle? For example, Jan 1-4 should have a value of On, while Jan 5 - 8 should be Off, and then have this repeat?

If so, try the following:
AddColumns(CalendarList,"OnOff",If(Mod(DateDiff(Date(2023,01,01),DateField),8)<4,"On","Off"))
If the on/off cycle doesn't start on 1/1, then of course adjust that date. If the calendar isn't just for the current year, that date can be from any year. It gets the number of days between the specified date and today, and uses MOD to do division and get the remainder, which effectively gets a number from 0 to 7 for each date. A value of < 4 is set to "On", 4-7 is set to "Off".

Or, perhaps I interpreted your question incorrectly.

Was this reply helpful? Yes No
HiteshM 33 on at

Like (0)

Report
Copy link

Link copied!

Thankyou for reply, the rota is for display purposes in the calendar. So visually individuals can see the days they are working and wether they need to book it off or not.
Don't really follow the logic above as i don't have list to create my calander. I used the in built template

Was this reply helpful? Yes No
Mike2500 1,247 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Ok, so, I'm still a little unclear on your requirement. You used the calendar template, as in, you created a new screen and used the calendar template there? You then customized the calendar to show a count of items in the leave requests list?

You mentioned the 4 day on/off cycle. Is this the same for every user who uses the app? If the user is viewing the calendar for October, 2023, what should the system show for Oct 1st, and how should it make that determination?

Was this reply helpful? Yes No
HiteshM 33 on at

Like (0)

Report
Copy link

Link copied!

Yes correct. October 1st would be day three and for every user bar 3 or 4

Was this reply helpful? Yes No
Verified answer

Mike2500 1,247 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Ok, so you want "3" to display on Oct 1, and "4" to display on Oct 5, etc., until 8, and then cycle back to 1.

If you add a label to the cell of the gallery, you can set it to:
Mod(DateDiff(Date(2019,12,31),DateAdd(_firstDayInView, ThisItem.Value, TimeUnit.Days)),8)+1
The above will generate a value from 1 to 8, based on which cell of the calendar it is in.

Was this reply helpful? Yes No
Verified answer

HiteshM 33 on at

Like (0)

Report
Copy link

Link copied!

Thankyou that works. Just need to colour code for the days in. Probably conditional formating

Was this reply helpful? Yes No
Mike2500 1,247 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You're welcome. But, so you know, please mark the answer as the solution, not your own comment as the solution. Thanks!

Was this reply helpful? Yes No