Hi all,
I couldn't quite figure out how to phrase this question, so I hope the following explanation makes sense. Data is system-generated CDS tables.
I have a series of time entries as follows:
| Date | Person | Project | Task | Hours | GUID |
| 03/20/21 | Jane | Data Modernization | Development | 4 | abcdef |
| 03/20/21 | Jane | Data Modernization | Meeting | 2 | 123456 |
I've used GroupBy to roll up to a project level:
| Date | Person | Project | Hours |
| 03/20/21 | Jane | Data Modern. | 6 |
However, I still need the separate GUIDs attached to the aggregated entry so I can use them elsewhere. What I'm hoping I can do is somehow concatenate them during the GroupBy to appear as follows:
| Date | Person | Project | Hours | GUIDs |
| 03/20/21 | Jane | Data Modernization | 6 | abcdef, 123456 |
Is this possible, or at least not horrendously complex? The existing aggregation formula is below:
AddColumns(
GroupBy(
AddColumns(
Filter(
'Time Entries','Time Entries (Views)'.'Time Entries for Approval',
Date > VarSelectedStartDate && Date < VarSelectedEndDate),
"DateString", Text(Date, ShortDate),"ResourceName",'Bookable Resource'.Name, "ProjectName", Project.'Project Name'),
"DateString","ResourceName","ProjectName","Data"),
"Hours",Sum('Data',Duration))
