Concat different entries if they share 2 same column entries

[RiccoHipp1903]

Hello guys,

I have the following thing I Want to achieve.

1.  I have a Collection

2. Employee

   Right

   Type of Access

3. For any Right and type of access I have an separated entrie.
4. Now I want to Patch the Collection to Dataverse Table 

The thing is I don't want to have different Entries if they share the same entries on 2 columns.

So if Employee and Type of Access are the same, all rights should concatenate together to a ',' separated entry

So i want to achieve, that it Looks like this 

Employee	Right	Type of Access
Berta, Berta	ZFA	Read
Berta, Berta	ZFA	Read
Erdbeer, Emily	ZFA_LOG	Read

If the same person has the same type of access, the rights should concat so that later on a patch is 

{Employee: "Berta, Berta" , Rights: "$Right1$, $Right2$, $Right3$.....", ToA: "Read"}

Berta, Berta	ZFA, ZFA	Read
Erdbeer, Emily	ZFA_LOG	Read

Is there an actual way to achieve my needs

PS: The names and the not 

[v-qiaqi-msft]

Hi @RiccoHipp1903,

Do you want to duplicate the records and save them into Dataverse?

You need to generate a new collection without duplicated records using the following formula:

ClearCollect(colNew, ForAll(Distinct(YourCollection, ThisRecord), Result))

Then Patch the collection to Dataverse as below:

ForAll(colNow,Patch(Table,Defaults(Table),{Column1:Employee,Column2:Right,Column3:TypeOfAccess}))

[RiccoHipp1903]

Yeah I got, why you think that. I described it badly because i had to hide sensitive info.

Example

Name	Right	ToA
Ricco	Right1	Read
Ricco	Right2	Read
Qi	Right1	Write
Qi	Right5	Edit

This should patch like this

Name	Right	ToA
Ricco	Right1, Right2	Read
Qi	Right1	Write
Qi	Right5	Edit

So in words: 

If the name and the type of Accesss are the same, The Rights should concatenate with a ',' as seperator - so that i got one entrie