
Hi all
Any help would be massively appreciated on this.
Thanks to some already great help on this forum, I am getting close to a solution to my problem, but I could do with some final pointers.
Basically, I have a vertical gallery running down the left hand side of the page with the following code:
AddColumns(
Office365Users.SearchUserV2(
{isSearchTermRequired:false}).value,
"weekData",
Filter(colTasks2,
CrewName.DisplayName=DisplayName &&
StartDate=_firstdayofweek &&
EndDate =_firstdayofweek +7
))
This displays all Office365users and filters them where they have a task set by STARTDATE and ENDDATE.
I then have a nested horizontal gallery sitting underneath 7 day columns. The item for the nested gallery is ThisItem.weekData (the ADDCOLUMN from the primary gallery).
I can get tasks to sort of appear, but I am unable to get them to successfully show for each correct date. _firstdayoftheweek is the variable for the start of the particular week. I have created a label for each task along the horizontal gallery with its text set to ThisItem.ProjectName.
The only issue I am having is with the logic within the PRIMARY GALLERY I think as I get an item appearing for each of the 7 days, even if the task starts after the _firstdayoftheweek or finishes before _firstdayoftheweek + 7?
Any ideas please?!