Unanswered

Remove member from a SharePoint group

(0) Share

Report

Posted on by SD-11121126-0

Hi,

I´ve created a flow removing members from a SharePoint group. However, sometimes the flow fails when the resource with the specified user ID does not exist. How can I fix this error? How to do a condition checking if the user is a member of the SharePoint group before removing?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Ninjasabi 122 on at

Like (0)

Report
If the user is using the "Remove member from group" connector, here's how to simplify the flow to avoid errors when the user is not a member of the group:

Step-by-Step Solution

1. Add the "Remove Member from Group" Action

Use the "Remove member from group" action to remove the user.

Input the SharePoint Group and the User's ID or Email Address.

2. Add a Simple Condition

Since the action fails if the user is not a member of the group, you can handle this with a Condition or a Run After configuration.

Option 1: Use a Condition to Check Membership

Before removing the user, check if they are a member of the group.

Use the "Get group members" action:

Input the SharePoint group ID.

The action will return a list of all members in the group.

Condition Configuration:

Add a Condition action after retrieving the group members.

Check if the user is in the list:

Expression:

contains(body('Get_group_members')?['value'], 'UserID or EmailAddress')

If Yes: Proceed to the "Remove member from group" action.

If No: Skip the removal.

Option 2: Use "Run After" to Handle Errors

Add the "Remove member from group" action directly.

Configure a fallback step (e.g., "Compose" or "Log").

Set "Run After" on the fallback step to handle cases where the action fails:

Click the ellipsis (...) on the fallback action and select "Configure run after."

Enable "has failed" and "has timed out."

Example Flow Outline:

Trigger: Manually trigger the flow or another appropriate trigger.

Get group members: Retrieve the current members of the SharePoint group.

Condition: Check if the user exists in the group:

Yes: Use the "Remove member from group" action.

No: Skip or log that the user is not a member.

Log Result: Log success or failure for transparency.

Why This Works

Option 1: Prevents the error by checking membership before removal.

Option 2: Gracefully handles errors without adding complex conditions.

Let me know if you need help with setting up the expressions or additional details! 😊

Was this reply helpful? Yes No
SD-11121126-0 6 on at

Like (0)

Report

@Ninjasabi, thanks for your suggested answer!

Is option 1 an efficient solution with over 1000 SharePoint members? How should I setup the expressions on the Condition?

Option 2, not sure how to set this up?

Was this reply helpful? Yes No