Check for inactive users in multi-person column in SharePoint list

(0) Share

Report

Posted on by sconner

I have a list of projects with a multi-person column listing all the internal stakeholders. I want to be able to report on when users become inactive and remove them from the list accordingly.

Currently inactive users remain in the list indefinitely and it becomes untidy.

What's the best way to check the user profiles for each of the stakeholders in each item? So far I've got:

- Get items

- @{items('Apply_to_each')?['Stakeholders']}

- Use the select data operation to get the list of each of the stakeholders' emails.

The output is an array of emails, but I need to separate these so I can check the user profile for each one.

[
  "person1@domain.co.uk",
  "person2@domain.co.uk",
  "person3@domain.co.uk"
]
 
How can I do this?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

CU25070820-1 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, you can use Apply to each (For each) to loop through the array.

Was this reply helpful? Yes No
Suggested answer

David_MA 15,350 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

This is an example of the apply to each mentioned by CU25070820-1. You want to have parallel actions under the Get user profile action to handle if the person is found or not. If the Get user profile action fails, that means the account is no longer active. You can then do what you need according to your requirements depending on whether the action is successful or not.

Was this reply helpful? Yes No