Share
Report
32If you have another way around this I am open to it!
I have an OnStart formula which populates a collection of timeslots
ClearCollect(
col30minSlots,
ForAll(
Sequence(47),
Time(0,30 *(Value),0)
));
Collect(col30minSlots,Time(0,0,1))
I have a SharePoint list which is copied into a collection, filtering down by todays date
ClearCollect(
CollStaffToday, Filter(Availability, 'Appointment Date'=Today()))
Then I have a gallery which shows the col30minslots collection, nesting within that is another gallery for the collstafftoday gallery with a formula to show availability between start and end time.
Filter(CollStaffToday,TimeValue('Start Time')<=ThisItem.Value And TimeValue('End Time') >=ThisItem.Value)
This all works but it may not be the best way of going about this ^^^^
I need a way to combine both collections into a single collection - is there any way to do this?
e.g.
| Time | Staff Name 1 | Staff Name 2 | Staff Name 3 | Staff Name 4 |
| 00:00 | Y | N | Y | Y |
| 00:30 | Y | N | Y | N |
| 01:00 | N | N | Y | Y |
| 01:30 | N | N | Y | N |
| 02:00 | Y | N | Y | Y |
| 02:30 | Y | Y | N | Y |
| 03:00 | Y | Y | N | N |
| 03:30 | Y | Y | N | N |
| 04:00 | N | Y | N | Y |
All responses (
Answers (
