Delete Users

Like (0) Share

Report

Posted on 21 Feb 2024 09:14:31 by Caleb62881177

765

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.

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

ivan_apps 2,187 Moderator on 21 Feb 2024 at 10:12:57

Like (1)

Report

Re: Delete Users

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 765 on 21 Feb 2024 at 10:17:17

Like (0)

Report

Re: Delete Users

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 on 21 Feb 2024 at 10:27:42

Like (1)

Report

Re: Delete Users

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 765 on 21 Feb 2024 at 13:04:13

Like (1)

Report

Re: Delete Users

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

Was this reply helpful? Yes No