Find missing names by comparing a group to a SharePoint List Column

[Thanasis]

Hello,

I really hope someone can help me with an issue I'm having. I have a 365 group with everybody from my company. What I want to do is compare that groups against a SharePoint list and find the names that are missing from that SharePoint list. Anybody have any thoughts on who would I do that? Any ideas would be really appreciated.

[abm]

Hi @Thanasis 

What does your SharePoint list contain? Could you explain using some sample data?

Thanks

[Thanasis]

Hello @abm ,

My list has different columns, on of those columns is called NameOfEmployee 

All of our employees need to fill out a form the information from that form goes to that SharePoint List including the name of the employee that filled the form. What I want is to take a 365 group that we have (we call it everyone and we add all our employees to it) and run it against that NameOfEmployee column and get back the names that are missing. So basically get the people that haven't filled the from so we can send them an email that they need to do it. Any thoughts on that ? Thank you for any help you can provide me.

[abm]

Hi @Thanasis 

Try the following and change the dynamic mapping accordingly.

Above I am checking the company name is present or not. You can change it accordingly.

Thanks

[Thanasis]

Hello @abm ,

I am not getting the same Filter quarry as you, what I get is  this :

am I doing something wrong ? 

And one more thing I know that is a lot to ask of you , but when I get the names of the people that are not in my original SharePoint List,  how would I go about sending them an email in that same flow ?

[Thanasis]

Hello @abm ,

If I use this

 This will take all the users we have ever created , is there a way to do just a group?. So lets say we have a group named everyone with 500 people in it. Howa can we use that specific group to run against our SharePoint list and immediately send them an email asking them to complete a form ? Any help you can provide me I would really appreciat.

Thank you  

[abm · Accepted solution]

Hi @Thanasis 

If you want to filter by group you need to use GRAPH API HTTP calls

First you need to find the Group Id.

https://graph.microsoft.com/v1.0/groups?$filter=startswith(displayName,'Everyone')

Suppose your group name is called 'Everyone' then the above will return the group id & other meta data details.

Once to find the id then use the next API method to return the members details

https://graph.microsoft.com/v1.0/groups/{GroupId}/members

Reference:

Get group - Microsoft Graph v1.0 | Microsoft Docs

If you need any further help in this please let me know.

Thanks

[Thanasis]

Thank you @abm  , I was able to resolve it with 

[crousseau]

How would you put this information into Power Automate? 

What I am trying to do is very similar. I have a group with job site leaders that have to fill out a safety report each week. I am trying to see who did not fill out a report for the week.

I've followed the steps, but I am unsure how to put the Graph information into Automate to compare the group to the SharePoint entries.

[abm]

Hi @crousseau 

Could you please create a new thread for this?

Thanks