Remove user from all user groups in Flow designer

[manu7867]

Hi All, We have a catalog item which is to remove user from all groups and for that we need to user Flow Designer, am new to Flow designer, please help me with this. we have Reference Variable with that we can select user.

[Uncle Rob · Accepted solution]

TRIGGER - Catalog Item
1.  Action -> Get Catalog Variables.  Select the catalog item and whatever variables you'll need for the flow
2.  Action -> Look Up Records (the plural one).  Table:  sys_user_grmember.  Conditions:  Where User = user variable from (1)
3.  Logic -> For Each of (2)
4.  Delete Record of (3)

[NaveenKumarDK]

Hi Rob,

I've created a similar flow which works well till delete record, now I've another requirement to extend the flow to send a mail to every user who have been removed from groups. I've added Send Email Action, but Its sending multiple mails as there are multiple groupmembership record for single user. I want to send single mail to every user.
Could you please help me with this? 

Thanks,

Naveen