Unanswered

Extracting the Display Name for a Json text/string value...from a Multiple Person Column

(0) Share

Report

Posted on by sasrsc1966

219

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"

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

BCLS776 8,994 Moderator on at

Like (0)

Report
Try:

Contacts: Concat(ThisRecord.Contacts.DisplayName,", ")

Hope that helps,

Bryan

Was this reply helpful? Yes No
Verified answer

sasrsc1966 219 on at

Like (1)

Report
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);

Was this reply helpful? Yes No