Get data from array variable

[DWTKBrook]

Hello all,

I have 2 lists one with a flow attached called GiftRegistry, in that flow I have a get items that looks up another list called Division Manager that has 2 columns, DivisionManager and DivisionName, My goal is to select the item with the value of the DivisionManager, filtered by DivisionName which I compare it to a column in the GiftRegistry also called DivisionName, both columns are choices and the choices are identical. Below is my configuration;

This is working fine, The output is as below;

{
  "DivisionName": {
    "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
    "Id": 5,
    "Value": "Private Equity"
  },
  "DivisionManager": {
    "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
    "Claims": "i:0#.f|membership|derek.LAST@Tenant.com",
    "DisplayName": "LAST, Derek",
    "Email": "derek.LAST@Tenant.com",
    "Picture": "https://TENANT.sharepoint.com/sites/teams/GBERegister/_layouts/15/UserPhoto.aspx?Size=L&AccountName=derek.LAST@Tenant.com",
    "Department": "Technology Services",
    "JobTitle": "Senior Analyst"
  }
}

the output is the correct information, now I  need to get the DisplayName from the array to use in a send email action so I created a string variable configure as

But the value ends up being

{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims":"i:0#.f|membership|derek.LAST@Tenant.com","DisplayName":"LAST, Derek","Email":"derek.LAST@Tenant","Picture":"https://Tenant.sharepoint.com/sites/teams/GBERegister/_layouts/15/UserPhoto.aspx?Size=L&AccountName=...","Department":"Technology Services","JobTitle":"Senior Analyst"}

How can I just get the display name property value? or is there any easier way to do this. 

I appreciate any help you can provide.

Thank you

[Expiscornovus]

Hi @DWTKBrook,

Can you try to change DivisionManager to DivisionManager/DisplayName?

In your existing expression that would be like the below:

first('DivisionManagerName')[0]['DivisionManager/DisplayName']

[DWTKBrook]

Hello @Expiscornovus ,

I attempted your suggestion but it seems to have triggered an error;

Here is how I configured the variable;

Is this correct?

Cheers!

[VictorIvanidze]

Try this:

first('DivisonManagerName')?['DivisonManager']?['DisplayName']

[Expiscornovus · Accepted solution]

Hi @DWTKBrook,

Apologies, I assumed your original expression already worked.

In that case try this (after having a proper look at your screenshots 😂)

first(variables('DivisionManagerName'))['DivisionManager/DisplayName']

[DWTKBrook]

Awesome, Thank you. That worked perfectly!

Thank you,