How do I automatically export Azure AD users (and their objects) to a sharepoint list every x minute

%3CLINGO-SUB%20id%3D%22lingo-sub-229082%22%20slang%3D%22en-US%22%3EHow%20do%20I%20automatically%20export%20Azure%20AD%20users%20(and%20their%20objects)%20to%20a%20sharepoint%20list%20every%20x%20minute%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-229082%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20automatically%20export%20Azure%20AD%20users%20(and%20their%20objects)%20to%20a%20sharepoint%20list%20every%2060%20minutes%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20provide%20a%20GAL%20that%20meets%20very%20specific%20UI%20requirements%20and%20where%20every%20user%20can%20search%20the%20GAL%20from%20their%20mobile%20device%20and%20edit%20their%20own%20entry.%20Even%20if%20no%20mail%20account%20is%20connected%20via%20Active%20Sync.%20But%20-%20and%20this%20is%20the%20special%20thing%20-%20the%20changes%20are%20not%20simply%20to%20be%20written%20back.%20These%20changes%20are%20to%20be%20forwarded%20to%20a%20relevant%20person%20and%20approved%20there.%20Then%20they%20are%20forwarded%20to%20an%20IT%20colleague%20and%20written%20back%20to%20AD.%20Can%20I%20do%20this%20with%20Powerapps%20and%20Flow%3F%20How%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-229082%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20AD%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-229090%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20automatically%20export%20Azure%20AD%20users%20(and%20their%20objects)%20to%20a%20sharepoint%20list%20every%20x%20mi%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-229090%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20highly%20suggest%20investing%20in%20Hyperfish%20for%20this%2C%20that's%20a%20very%20large%20amount%20of%20work%20to%20accomplish%20this%20if%20you%20try%20doing%20it%20manually.%20Hyperfish%20provides%20a%20way%20to%20e-mail%20people%20for%20updates%2C%20they%20make%20changes%2C%20the%20changes%20can%20be%20directed%20to%20manager%20or%20any%20individuals%20you%20designate%20for%20approval%20before%20those%20changes%20are%20wrote%20back%20to%20AD.%20You%20can%20customize%20the%20data%20fields%20that%20go%20in%2C%20values%2C%20all%20kinds%20of%20things.%20Not%20to%20mention%20it's%20mobile%20friendly%20and%20they%20have%20a%20Teams%20Bot%20and%20SharePoint%20webpart%20as%20well%20for%20it.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20could%20do%20it%20in%20flow....%20but%20I%20would%20rather%20not%20reinvent%20the%20wheel%2C%20cause%20the%20cost%20of%20Hyperfish%20is%20way%20less%20than%20the%20time%20you'll%20spend%20trying%20to%20get%20that%20to%20work%2C%20assuming%20it%20can%20meet%20your%20needs%2C%20but%20sounds%20like%20it%20from%20first%20look.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

How do I automatically export Azure AD users (and their objects) to a sharepoint list every 60 minutes?

 

I need to provide a GAL that meets very specific UI requirements and where every user can search the GAL from their mobile device and edit their own entry. Even if no mail account is connected via Active Sync. But - and this is the special thing - the changes are not simply to be written back. These changes are to be forwarded to a relevant person and approved there. Then they are forwarded to an IT colleague and written back to AD. Can I do this with Powerapps and Flow? How?

1 Reply

I would highly suggest investing in Hyperfish for this, that's a very large amount of work to accomplish this if you try doing it manually. Hyperfish provides a way to e-mail people for updates, they make changes, the changes can be directed to manager or any individuals you designate for approval before those changes are wrote back to AD. You can customize the data fields that go in, values, all kinds of things. Not to mention it's mobile friendly and they have a Teams Bot and SharePoint webpart as well for it. 

You could do it in flow.... but I would rather not reinvent the wheel, cause the cost of Hyperfish is way less than the time you'll spend trying to get that to work, assuming it can meet your needs, but sounds like it from first look.