I'm stuck on something and am hoping someone can help me.
I have an app that is used to track time on project tasks. Each Project has an associated Task List (all of my data sources are SharePoint lists). From the Project Task List screen, stakeholders want to be able to "pin" tasks to their timesheet. So that when they click on a Timesheet button, they will be served up with a gallery of tasks that they have pinned to their timesheet.
On my Project Task list, when a user clicks on the "pin" icon in the screenshot below, I add a record to a CSUserPinnedTasks SharePoint list. That list stores:
- UserName
- UserEmail
- TaskID (from my CSProjectTasks list)
This part is working fine.
On my Timesheet screen I'm trying to dynamically serve up a gallery of tasks for the logged in user. I'm creating one collection called ColPinnedTasks that stores the TaskIDs for the logged in user, from the CSUserPinnedTasks list. This part is also working and I can see that it is collecting the data correctly.
Now I'm trying to create second collection called ColPinnedTaskDetails that loops through the IDs in the first collection to pull the task details from my CSProjectTasks list where the ID in the CSProjectTasks list matches the TaskID from the first collection. This is the formula that I have in my Timesheet screen OnVisible property.
ClearCollect(ColPinnedTasks,CSUserPinnedTasks);
Clear(ColPinnedTaskDetails);
ForAll(ColPinnedTasks,
Collect(ColPinnedTaskDetails, CSProjectTasks, ID=ThisRecord.TaskID));
The ColPinnedTasks collection is working and my formula is not giving me any errors, however, the ColPinnedTaskDetails collection is not capturing any records.
Any help or insight is greatly appreciated!
