745
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.
@v-yetonggu-msft @ivan_apps - Thank you both for your speedy response, I really appreciate all your efforts.
Hi @Caleb62881177 ,
I did a test for your reference.
Delete User Before:
Delete User After:
In my scenario:
Best Regards,
Sunshine Gu
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?
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:
Share
Report
All responses (
Answers (
