Add Column To HTML Table (Within Apply To Each Loop)

Like (0) Share

Report

Posted on 17 Apr 2023 18:05:24 by bcanfield83

Hi All,

I'm struggling with what seems like a relatively easy solution. Ultimately, I'm trying to create a HTML Table containing 3 columns:

User
Job Title
Manager

The User and Job Title columns are being pulled from the Azure AD Get group members action:

However, this does not include the Manager value for each of the users assigned to the specified AD Group. Thus, I added an "Apply to each" loop which pulls each user's manager via the Get manager (V2) action:

This works as expected - but what I'm trying to do from here is add a "Manager" column to the HTML table and insert the manager value (for each user).

I'm sure it's a lot simpler than I'm making it out to be, so any help is appreciated. Thanks!

I have the same question (0)

All responses (2)

Answers (1)

bcanfield83 56 on 28 Apr 2023 at 11:30:31

Like (0)

Report

Re: Add Column To HTML Table (Within Apply To Each Loop)

Thank you!

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft on 18 Apr 2023 at 02:19:51

Like (1)

Report

Re: Add Column To HTML Table (Within Apply To Each Loop)

Hi @bcanfield83 ,

I made a sample for you.

{
"User":@{items('Apply_to_each')?['displayName']},
"jobTitle":@{items('Apply_to_each')?['jobTitle']},
"ManagerName":@{outputs('Get_manager_(V2)')?['body/displayName']}
}

Best Regards,

Wearsky

Was this reply helpful? Yes No