How to get multiple user's name from a share point list ?

[Calven_Chow]

Hi, 

I would like to ask, 

I'm facing a issue when I want to create a HTML table by get user's name from Share Point List, in the SP list column : Assigned Owner, contain two user. When I want get the value into HTML table, the output it will show " @odate.type " / "Email" / " Picture" / etc. I would like to get the "Display Name" only. 

Assigned Owner

[{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims":"|membership|userA@email.com","DisplayName":"UserA","Email":"userA@email.com","Picture":"picture of userA","Department":" ABC ","JobTitle":"work"},[{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims":"|membership|userB@email.com","DisplayName":"UserB","Email":"userB@email.com","Picture":"picture of userB","Department":" DEF ","JobTitle":"work"},

Wish To Get:

Assigned Owner

UserA , UserB

[v-xiaochen-msft · Accepted solution]

Hi  @Calven_Chow ,

I made a sample for you.

{"Display Name":@{join(body('Select'),',')}}

Best Regards,

Wearsky

[Calven_Chow]

@v-xiaochen-msft 

As the following the step above, it show: 

Display Name

-----------------------

{"userA":"},{"userA":"},

{"userB":"},{"userB":"},

{"userA":"},

{"userC":"},{"userC":"}

How can I get the format as the outputs above ? Will it because of to apply_to_each showing on the flow ? (the apply_to_each created automatically after I select "Assigned to"

[v-xiaochen-msft]

Hi @Calven_Chow ,

Could you expand all actions and show all expressions?

Best Regards,

Wearsky

[Calven_Chow]

@v-xiaochen-msft 

Sure sure,

Flow:

SP List:

Outputs:

[v-xiaochen-msft]

Hi @Calven_Chow ,

Sorry for late reply.

I noticed that you have a nested 'Apply to each' action in your flow.

Please remove it.

Best Regards,

Wearsky

[Calven_Chow]

Hi @v-xiaochen-msft ,

The "Apply to each" unable to be remove, i believe is because of the "value" that i collect in the SP List. 

When I choice "Assign to" in [Select], it will automatically create "Apply to each"|

Any other way to have remove the "Apply to each" ?

Thank You

Calven

[v-xiaochen-msft · Accepted solution]

Hi @Calven_Chow ,

I think the 'Assign to' filed is a person/group field which allows multiple selections, right?

Please try to remove the 'Apply to each 2' action and add the Select and 'Append to array variable' again.

The point is to input the expression manually instead of using the dynamic content.

In you case, try these expression:

Select From: items('Apply_to_each')?['Assign to']

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

Besides, I found that you hadn't click on the button of the select action, please click it first and then fill in the Map parameter.

Hope it makes sense.

Best Regards,

Wearsky