How to get mapped values to use in Email

[lopezbec]

I have a flow that gets Approvers from a list in Sharepoint and it creates an approval.  When the approval is created, I want to show the Display Name in the create approval step and not the email addresses so that the approvers know everyone this was sent to.

I get the Approvers based upon a department and there can be one to many approvers.

From that, I Select the outputs and Map Email to use for the Create Approval step

From: outputs('Get_items_-_Approvers_for_Department')?['body/value']?[0]?['Approvers']

Map: ()item?['Email']

I then join the output from Select Email and set my strApprovers variable.

Next Step I select Claims to get email 

From: outputs('Get_items_-_Approvers_for_Department')?['body/value']?[0]?['Approvers']

Map: Claims item()?['Claims']

Next Step I select claims to get Display Name.

From: outputs('Get_items_-_Approvers_for_Department')?['body/value']?[0]?['Approvers']

Map: DisplayName item()?['DisplayName']

I take the output from the DisplayName and initialize a variable called strDisplayName

I keep these separate because one is used for the create approval and one is used for updating file properties later and if they are combined it doesn't work.

Here is the output for DisplayName.

 

In the Create Approval I use the variable strDisplayName to show who the approvals went to, but it is not in very user friendly format because it includes the Displayname field and the {}

How can I change this so that it displays only with user name1, user name 2, etc?

[abm]

Hi @lopezbec 

Try the below after the Select actions step 

Add  a Compose and add the below expression

body('Select_Claims_for_Display_Name_in_Create_Approval')?[0]?['DisplayName']

Add another compose and add the below expression

body('Select_Claims_for_Display_Name_in_Create_Approval')?[1]?['DisplayName']

If you want to add together use Concat() expression in one compose action step.

Contact(body('Select_Claims_for_Display_Name_in_Create_Approval')?[0]?['DisplayName'], ' ',body('Select_Claims_for_Display_Name_in_Create_Approval')?[1]?['DisplayName'])

Thanks

[lopezbec]

@abm There was a typo in your function.  You have Contact instead of Concat, but I knew what you were going for.  Thanks for your prompt response.  This worked; however, is there a way when concatenating that I can separate the names with a comma?  I could have cases where there are 4 or 5 names and I want it to be a bit easier to read.  I could have some last names that may appear as first names and it may get confusing if I don't separate by comma.

[abm · Accepted solution]

Hi @lopezbec 

Yes I meant by concact. See below I have added a comma between.

Concat(body('Select_Claims_for_Display_Name_in_Create_Approval')?[0]?['DisplayName'], ' ,',body('Select_Claims_for_Display_Name_in_Create_Approval')?[1]?['DisplayName'])