Flow based on Azure ad group

[dgoguet]

Hi!

I am planning to create a flow on request to our HR department.

The goal is to launch an approval worflow on each new user of a specific AD Group for him to accept the general rules of usage.

I was thinking about getting the list of users using the "Azure AD get group members" component to populate a list of users to which I'll add fields regarding the approving status, datetime, comments... and trigger the approval worflow from new items in this list.

My main question is: 

is there a way to get only new members of the AD Group?

Another option would be to get the full list at each run (even if not very efficient) and check if the user already exists in the list or not, but I can't figure out how.

Any help appreciated!

Thanks 

[dgoguet]

I seem to have found the solution for the second option, even if really not effective, as we have +700 users.

So, question still open for:

is there a way to get only new members of the AD Group?

[fchopo · Accepted solution]

Hello @dgoguet 

You could try to us the Azure AD Graph API and the get the most recent added users to Azure AD using the user:delta operation.

To use the Graph API inside a flow, please read this great article by Laura Kokkarinen.

Hope it helps!

Ferran

[dgoguet]

Thanks for the suggestion, I'll have a look!