Power Platform Community Forum Thread Details

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?!

Categories:

Building Power Apps