cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Thanasis
Helper IV
Helper IV

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

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.

1 ACCEPTED SOLUTION

Accepted Solutions

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

View solution in original post

9 REPLIES 9
abm
Super User
Super User

Hi @Thanasis 

 

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

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Hello @abm ,

 

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

Thanasis_0-1612877068988.png

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.

Hi @Thanasis 

 

Try the following and change the dynamic mapping accordingly.

 

image.png

image.png

 

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

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Hello @abm ,

 

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

Thanasis_0-1612969756279.png

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
Helper IV
Helper IV

Hello @abm ,

If I use this

Thanasis_0-1613047733415.png

 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  

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
Thanasis
Helper IV
Helper IV

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

crousseau
Frequent Visitor

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.

Hi @crousseau 

 

Could you please create a new thread for this?

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,071)