Converting array of UPNs to an Array of Display Names

[vivekmurli]

Hi Team,

We have a scenario where we need to get a UPN column from SQL Server and convert the UPNs to their respective display names. The challenge is that the office 365 connector only accepts a single parameter and converts all the other UPNs to a single value(display name) e.g.  If  the column has 2 UPNs namely abc@abc.com and xyz@abc .com , the display names would be abc , abc .

Any suggestions would be appreciated.

[VictorIvanidze]

If a column contains several UPNs, convert them to array.

[v-bofeng-msft]

Hi @vivekmurli :

Please use the "Append to string variable" action.

Best Regards,

Bof

[vivekmurli]

Thank you for the response Bof,

I followed the steps and getting all the display names , However the challenge is that it is displaying all the Display names in all the cells as shown below.

Is there a way to put these display names against the respective entries as a separate column as shown below

Please let me know if you need more info.