Power Platform Community Forum Thread Details

With a multi-select people field, called 'Plus One', I can concatenate the DisplayName with this formula in the Text property of a gallery label:

If(!IsBlank(Concat(ThisItem.'Plus One'.DisplayName,DisplayName,"; ")),Concat(ThisItem.'Plus One'.DisplayName,DisplayName,"; "),"TBD")

The DisplayName is formatted as LastName, FirstName MiddleNameOrInitial Rank and other fields after the rank.

This formula only brings back the first name in the 'Plus One' Text Label and I need it to bring in all the people in the same format.

// This works but only brings in the first person
If(IsBlank(Concat(ThisItem.'Plus One',DisplayName,"; ")),"TBD",
Concatenate(Last(FirstN(Split(Concat(ThisItem.'Plus One'.DisplayName,DisplayName)," "),4)).Value," ",First(Split(Concat(ThisItem.'Plus One'.DisplayName,DisplayName," ")," ")).Value))

Result is MG Jones

I need it to be MG Jones, CSM Smith, and any others in that field.

I can't figure out where to put a ForAll and a Concatenate to get all the values in the 'Plus One' multi-select people field.

Any help is greatly appreciated!

Categories:

Building Power Apps