Clear(colUsers);
Clear(colEmails);
Clear(colUsers2);
Clear(colEmails2);
ForAll(
Data As Item,
With(
{
Users: Split(
Item.nmResponsavel,
"; "
),
Emails: Split(
Item.mailResponsavel,
"; "
)
},
//Collect Users
Collect(
colUsers,
Users
);
//Collect Emails
Collect(
colEmails,
Emails
)
)
);
//Add Row Number
ClearCollect(
colUsers,
ForAll(
Sequence(CountRows(colUsers)),
Patch(
Last(
FirstN(
colUsers,
Value
)
),
{RowNumber: Value}
)
)
);
//Add Row Number
ClearCollect(
colEmails,
ForAll(
Sequence(CountRows(colEmails)),
Patch(
Last(
FirstN(
colEmails,
Value
)
),
{RowNumber: Value}
)
)
);
//Change Column Name to User
ClearCollect(
colUsers2,
RenameColumns(
colUsers,
Value,
User
)
);
//Change Column Name to Email
ClearCollect(
colEmails2,
RenameColumns(
colEmails,
Value,
Email
)
);
//Final Collection with Email and Blank User Column
ClearCollect(
colFinal,
AddColumns(
colEmails2,
User,
" "
)
);
//Patch User to the final collection using a LookUp
ForAll(
colFinal As Item,
Patch(
colFinal,
Item,
{
User: LookUp(
colUsers2,
RowNumber = Item.RowNumber
).User
}
)
)
Here's my final collection (colFinal):
My code is long but works. Hoping someone would be able to come up with a shorter version of this.
Hope this helps.
Kind regards,
Nandit
If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!
