Hi all,
didn't think this would be a problem but here I am anyways.
I have two tables
Table1 Days
ID | Day
1 | Day 1
2 | Day 2
3 | Day 3
Table2 Emails Per Day
ID | Day ID | Email
1 | 1 | some email1
2 | 2 | some email 2
3 | 1 |some email 3
4 | 2 |some email 4
5 | 3 |some email 5
What I need to accomplish is to add a Column to Table 1 that displays the concatenated emails of Table2 based on the Matching ID
So the output would be this
ID | Day | Emails
1 | Day 1 | some email1, some email3
2 | Day 2 | some email2, some email4
What I tried is this, but it does not give me desired output
ClearCollect(CollectionTable1,AddColumns(Table1,"Emails",Concat(Filter(Table2, DayID = ID),Emails,", ")))
I was fiddling around with a ForAll inside of this but to avail
Can anyone point me in the right direction?
