Unanswered

Converting array of UPNs to an Array of Display Names

(0) Share

Report

Posted on by 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.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

VictorIvanidze 13,073 on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (1)

Report

Hi @vivekmurli :

Please use the "Append to string variable" action.

Best Regards,

Bof

Was this reply helpful? Yes No
vivekmurli 5 on at

Like (0)

Report

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.

Was this reply helpful? Yes No