ForAll(
GalRequests.AllItems,
Collect(
itemsForCsv,
{
ID: ThisRecord.ID,
Contacts: ThisRecord.Contacts.DisplayName
}
)
);
I am creating a collection that I will convert to JSON for a user to be able to Export to a CSV (using Flow).
My question is that ThisRecord.Contacts is a multiple person column in SP.
In my ForAll (which is looping through my Gallery Items) I need to produce a "Contacts:" object containing the DisplayNames of each person but stored as a single string. Just not sure how to do this syntax.
So hence the result would be etc....
"Contacts": "Batman, Mickey Mouse, Freddie Mercury"
Solved! Go to Solution.
Thank you @BCLS776 .. that got me headed in the right direction...
The correct answer was ...
Contacts: Concat(ThisRecord.Contacts.DisplayName,DisplayName,", "),
and here it is in the entire onSelect property...
ForAll(
GalRequests.AllItems,
Collect(
itemsForCsv,
{
ID: ThisRecord.ID,
Title: ThisRecord.Title,
Status: ThisRecord.Status,
Contacts: Concat(ThisRecord.Contacts.DisplayName,DisplayName,", "),
DateTimeUTC: ThisRecord.'Air Date Time',
WebinarDateTime: Text(DateTimeValue(ThisRecord.'Air Date Time'),DateTimeFormat.ShortDateTime),
WebinarDate: Text(DateTimeValue(ThisRecord.'Air Date Time'),DateTimeFormat.ShortDate),
Duration: ThisRecord.Duration,
Sector: ThisRecord.'Sector Target',
'Key Focus': ThisRecord.'Key Focus',
Format: ThisRecord.'Format Options',
CreatedBy: ThisRecord.'Created By'.DisplayName,
ModifiedBy: ThisRecord.'Modified By'.DisplayName,
Created: ThisRecord.Created,
Modified: ThisRecord.Modified
}
)
);
Notify(
"An Excel file is being created. It will save on your OneDrive location",
NotificationType.Information,
3000
);
Set(
fileOpen,
ExportToExcel.Run(
JSON(
itemsForCsv,
JSONFormat.IncludeBinaryData & JSONFormat.IgnoreUnsupportedTypes
),
"Webinars"
).filelink
);
Launch(fileOpen);
Clear(itemsForCsv);
Try:
Contacts: Concat(ThisRecord.Contacts.DisplayName,", ")
Hope that helps,
Bryan
Thank you @BCLS776 .. that got me headed in the right direction...
The correct answer was ...
Contacts: Concat(ThisRecord.Contacts.DisplayName,DisplayName,", "),
and here it is in the entire onSelect property...
ForAll(
GalRequests.AllItems,
Collect(
itemsForCsv,
{
ID: ThisRecord.ID,
Title: ThisRecord.Title,
Status: ThisRecord.Status,
Contacts: Concat(ThisRecord.Contacts.DisplayName,DisplayName,", "),
DateTimeUTC: ThisRecord.'Air Date Time',
WebinarDateTime: Text(DateTimeValue(ThisRecord.'Air Date Time'),DateTimeFormat.ShortDateTime),
WebinarDate: Text(DateTimeValue(ThisRecord.'Air Date Time'),DateTimeFormat.ShortDate),
Duration: ThisRecord.Duration,
Sector: ThisRecord.'Sector Target',
'Key Focus': ThisRecord.'Key Focus',
Format: ThisRecord.'Format Options',
CreatedBy: ThisRecord.'Created By'.DisplayName,
ModifiedBy: ThisRecord.'Modified By'.DisplayName,
Created: ThisRecord.Created,
Modified: ThisRecord.Modified
}
)
);
Notify(
"An Excel file is being created. It will save on your OneDrive location",
NotificationType.Information,
3000
);
Set(
fileOpen,
ExportToExcel.Run(
JSON(
itemsForCsv,
JSONFormat.IncludeBinaryData & JSONFormat.IgnoreUnsupportedTypes
),
"Webinars"
).filelink
);
Launch(fileOpen);
Clear(itemsForCsv);
User | Count |
---|---|
167 | |
90 | |
73 | |
67 | |
57 |
User | Count |
---|---|
213 | |
153 | |
97 | |
88 | |
68 |