Concatenating to string from GroupBy items

[RMDNA]

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))

[rubin_boer · Accepted solution]

hi @RMDNA add another column. 

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)

,"Guids",
Concat('Data', Guid & ", "))

Then add another label to your gallery with Text = Left(ThisItem.Guids,Len(ThisItem.Guids)-2)

hope it helps 

[RMDNA]

That was a lot simpler than I thought it would be. Thank you!