Hi all,
I have a process that currently returns all the unique people from a person column in a sharepoint list. It then displays the data in a CSV file with name and email.
The data set for this look like:
The end result looks like:
The code in PowerApps that builds the collection that then gets sent to a flow to turn into a CSV, looks like this:
"Export Report Owner Names/Emails",
ClearCollect(colUniqueReportOwnerEmails,
GroupBy(
Filter(
Ungroup(ERR_ComplianceData, "ReportOwner"),
ReportStatus.Value="Live" || ReportStatus.Value="Adhoc"),"DisplayName","Email","Picture", "GroupedData" ));
ForAll(colUniqueReportOwnerEmails,Collect(colUniqueReportOwnerEmails_Final,
{'Report Owner - Name': ThisRecord.DisplayName,
'Report Owner - Email': ThisRecord.Email}));
//Run flow to create the file on One Drive
Set(varExcelFileLink_ReportOwners,
ERR_ExportReportOwnersToExcel.Run(JSON(colUniqueReportOwnerEmails_Final,
JSONFormat.IgnoreBinaryData & JSONFormat.IgnoreUnsupportedTypes)).filelink);
Clear(colUniqueReportOwnerEmails);
Clear(colUniqueReportOwnerEmails_Final);
//Launch the file
Launch(varExcelFileLink_ReportOwners),
As you can see, this code simply looks at the ReportOwner person column and unpacks it, gets the unique value and then send the collection to PowerAutomate.
What I now need to add here is the Community column, so the the end output looks like:
Can anyone help me with the changes required for this please?
Thanks.
