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

(0) Share

Report

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

Categories:

Using flows

I have the same question (0)

All responses (7)

Answers (2)

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Calven_Chow ,

I made a sample for you.

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

Best Regards,

Wearsky

Was this reply helpful? Yes No
Calven_Chow 16 on at

Like (0)

Report
Copy link

Link copied!

@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"

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Calven_Chow ,

Could you expand all actions and show all expressions?

Best Regards,

Wearsky

Was this reply helpful? Yes No
Calven_Chow 16 on at

Like (0)

Report
Copy link

Link copied!

@v-xiaochen-msft
Sure sure,
Flow:

SP List:

Outputs:

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Calven_Chow 16 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No