Update User Office 365 Profiles using SharePoint and Flow (Power Automate)

%3CLINGO-SUB%20id%3D%22lingo-sub-1263112%22%20slang%3D%22en-US%22%3EUpdate%20User%20Office%20365%20Profiles%20using%20SharePoint%20and%20Flow%20(Power%20Automate)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1263112%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20use%20power%20automate%20to%20update%20user%20Office%20365%20profiles%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20our%20case%2C%20the%20IT%20staff%20maintains%20Office%20365%20user%20accounts.%26nbsp%3B%20However%2C%20changes%20are%20always%20occurring%20with%20regards%20to%20specific%20controlled%20fields%20in%20user%20profiles%20(i.e.%20company%2C%20department%2C%20or%20manager).%26nbsp%3B%20Invariably%2C%20errors%20occur%20as%20the%20IT%20staff%20has%20to%20interpret%20emails%20sent%20to%20them%20from%20HR%20to%20be%20input%20in%20the%20employee%20Office%20365%20profile%20information%20(which%20later%20get%20used%20in%20power%20automation%20for%20internal%20processes).%26nbsp%3B%20The%20result%20is%20that%20an%20employee%20request%20gets%20sent%20to%20the%20wrong%20manager%20(because%20the%20Power%20Automation%20uses%20%22Get%20Manager%22%2C%20which%20was%20set%20by%20IT%20staff%20incorrectly).%26nbsp%3B%20Certain%20user%20profile%20information%20should%20really%20be%20HR%20controlled%2C%20so%20I'm%20thinking%20to%20allow%20HR%20to%20make%20changes%20to%20Office%20365%20profile%20information%20via%20a%20SharePoint%20list%2C%20which%20has%20Power%20Automation%20behind%20it%20to%20update%20the%20actual%20Office%20365%20profile%20fields.%26nbsp%3B%20The%20list%20will%20be%20made%20specific%20to%20the%20fields%20HR%20should%20have%20the%20responsibility%20to%20update.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHas%20anyone%20done%20this%20before%3F%26nbsp%3B%20Or%2C%20does%20anyone%20have%20a%20better%20solution%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1263112%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1264052%22%20slang%3D%22en-US%22%3ERe%3A%20Update%20User%20Office%20365%20Profiles%20using%20SharePoint%20and%20Flow%20(Power%20Automate)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1264052%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3EAre%20you%20maintaining%20a%20separate%20source%20for%20the%20user%20information%3F%20Are%20you%20using%20the%20Azure%20AD%20directly%20or%20connected%20to%20on-prem%20AD%3F%3CBR%20%2F%3EFor%20updating%20the%20information%20from%20SharePoint%20list%20to%20Office%20365%20Profile%20information%2C%20you%20can%20use%20Graph%20API%20in%20the%20Power%20Automate.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Is there a way to use power automate to update user Office 365 profiles? 

 

In our case, the IT staff maintains Office 365 user accounts.  However, changes are always occurring with regards to specific controlled fields in user profiles (i.e. company, department, or manager).  Invariably, errors occur as the IT staff has to interpret emails sent to them from HR to be input in the employee Office 365 profile information (which later get used in power automation for internal processes).  The result is that an employee request gets sent to the wrong manager (because the Power Automation uses "Get Manager", which was set by IT staff incorrectly).  Certain user profile information should really be HR controlled, so I'm thinking to allow HR to make changes to Office 365 profile information via a SharePoint list, which has Power Automation behind it to update the actual Office 365 profile fields.  The list will be made specific to the fields HR should have the responsibility to update. 

 

Has anyone done this before?  Or, does anyone have a better solution?

1 Reply
Highlighted
Hi,
Are you maintaining a separate source for the user information? Are you using the Azure AD directly or connected to on-prem AD?
For updating the information from SharePoint list to Office 365 Profile information, you can use Graph API in the Power Automate.