Delete Users

(0) Share

Report

Posted on by Caleb62881177

789

Hello Everyone,

I would like to build a flow that loops through a SharePoint List and checks if the users in AD users are also present in the SharePoint List that contains DisplayNames of a user and deleted SharePoint List column if the user doesn't exist in AD, but exist in the SharePoint List.

Example:

SharePoint List

AD Accounts

Output:

SharePoint List after the flow has ran successfully.

I hope my examples helps.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

ivan_apps 2,189 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Should be easy enough to use the Entra ID Get Users action, enter the EmailAddress column and see if it fails or not. Unfortunately when a user retrieval is not found the result is not an empty array or "Not Found", the action will error. So you will have to add an action after the error that has a 'Run After' configuration that is only for the 'Get Users' failed condition, as well as a success condition.

It would end up looking like this:

Was this reply helpful? Yes No
Caleb62881177 789 on at

Like
a
(0)

Report
Copy link

Link copied!

HI @ivan_apps ,
Sorry, I still haven't gotten used to the new designer of Power Automate.

Is it possible to post the old designer of Power Automate and expanded the Actions, please?

Was this reply helpful? Yes No
Verified answer

v-yetonggu-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Caleb62881177 ,

I did a test for your reference.

Delete User Before:

Delete User After:

In my scenario:

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Caleb62881177 789 on at

Like
a
(1)

Report
Copy link

Link copied!

@v-yetonggu-msft @ivan_apps - Thank you both for your speedy response, I really appreciate all your efforts.

Was this reply helpful? Yes No