Sync Custom Active Directory Attributes with SharePoint Online User Profiles

%3CLINGO-SUB%20id%3D%22lingo-sub-30663%22%20slang%3D%22en-US%22%3ESync%20Custom%20Active%20Directory%20Attributes%20with%20SharePoint%20Online%20User%20Profiles%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-30663%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20requirement%20from%20a%20customer%20that%20goes%20something%20like%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20be%20able%20to%20target%20content%20(think%20Announcements%20and%20News).%20So%20I%20am%20going%20down%20the%26nbsp%3BUser%20Profile%20Properties%20path%20and%20create%20Site%20Columns%20to%20tag%20the%20content%20and%20use%20the%20Content%20Search%20Web%20Part%20to%20rollup%20the%20information%20and%20match%20a%20user%20property%20value%20with%20the%20Site%20Column%20Value...Easy%20right.....%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%2C%20what%20if%20a%20user%20is%20a%20member%20of%20multiple%20departments%20let's%20say%20but%20the%20Department%20Profile%20Property%20only%20allows%20for%20a%20single%20value%3F%20I%20can%20create%20a%20new%20multi%20valued%20user%20property%20to%20hold%20multiple%26nbsp%3Bvalues%20in%20there%20and%20that%20should%20work..%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20I%20can%20sync%20a%20custom%20Active%20Directory%20Attribute%20of%20users%20that%20hold%20muliple%20values%20with%20a%20Custom%20SharePoint%20User%20Profile%20Property%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHas%20anyone%20implemented%20such%20a%20thing%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-30663%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPnP%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-118542%22%20slang%3D%22en-US%22%3ERe%3A%20Sync%20Custom%20Active%20Directory%20Attributes%20with%20SharePoint%20Online%20User%20Profiles%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-118542%22%20slang%3D%22en-US%22%3E%3CP%3EHI%20Medardo%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20now%20at%20least%2C%20there%20is%20no%20option%20to%20sync%26nbsp%3Bcustom%20Active%20Directory%20attributes%20with%20SharePoint%20Online%20automatically.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20followed%20the%20instructions%20of%20this%20article%26nbsp%3Band%20implemented%20a%20console%20application%20that%20do%20the%20job.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fmsdn.microsoft.com%2Fen-US%2Fpnp_articles%2Fbulk-user-profile-update-api-for-sharepoint-online%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmsdn.microsoft.com%2Fen-US%2Fpnp_articles%2Fbulk-user-profile-update-api-for-sharepoint-online%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20Regards!%3C%2FP%3E%3CP%3ESergio.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-118537%22%20slang%3D%22en-US%22%3ERe%3A%20Sync%20Custom%20Active%20Directory%20Attributes%20with%20SharePoint%20Online%20User%20Profiles%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-118537%22%20slang%3D%22en-US%22%3E%3CP%3EHi.%26nbsp%3B%20I%20have%20the%20same%20necessity.%26nbsp%3B%20I%20have%20the%20custom%20attribute%20in%20AAD.%26nbsp%3B%20I%20need%20a%20way%20to%20get%20it%20over%20to%20SharePoint%20user%20profile.%26nbsp%3B%20Any%20suggestions%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-102127%22%20slang%3D%22en-US%22%3ERe%3A%20Sync%20Custom%20Active%20Directory%20Attributes%20with%20SharePoint%20Online%20User%20Profiles%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-102127%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Guys%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20news%20about%20SharePoint%20Online%20User%20Profile%20Sync%20with%20AAD%20Connect%20custom%20mapped%20properties%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELet%20me%20explain%20a%20little%2C%20i%20need%20some%20custom%20properties%20already%20mapped%20on%20AAD%20Connect%20on%20SharePoint%20User%20Profile%2C%20on%20my%20research%20i%20cannot%20find%20any%20way%20except%20developing%20OOB%20script%2FEXE%20to%20perform%20this%20action.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20Regards%2C%3C%2FP%3E%3CP%3ESergio.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-30907%22%20slang%3D%22en-US%22%3ERe%3A%20Sync%20Custom%20Active%20Directory%20Attributes%20with%20SharePoint%20Online%20User%20Profiles%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-30907%22%20slang%3D%22en-US%22%3E%3CP%3EYeah%20i%20have%20heard%20that%20the%20current%20AAD%20Connect%20does%20custom%20attributes.%20i%20guess%20i%20still%20need%20to%20get%20those%20custom%20attributes%20into%20a%20SharePoint%20Online%20User%20Profile.%20I%20would%20like%20to%20avoid%20audiences%20in%20SharePoint%20Online%20if%20possible%20because%20of%20the%20lack%20of%20control%20of%20compilation%20schedule%2C%20unless%20that%20has%20changed%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20i%20can%20get%20these%20custom%20attributes%20synced%20by%20aad%20connect%20then%20into%20sp%20online%20that%20would%20be%20ideal.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-30904%22%20slang%3D%22en-US%22%3ERe%3A%20Sync%20Custom%20Active%20Directory%20Attributes%20with%20SharePoint%20Online%20User%20Profiles%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-30904%22%20slang%3D%22en-US%22%3E%3CP%3EUsing%20the%20last%20Azure%20AD%20Connect%20you%20can%20push%20custom%20AD%20Attributes%20to%20Azure%20AD%20and%20Office%20365.%20Why%20not%20using%20this%20feature%20to%20keep%20sync%20a%20local%20AD%20multi%20valued%20attributes%20and%20using%20it%20from%20SharePoint%20User%20Profil%20to%20build%20a%20new%20Audience%3F%20That%20should%20work.%20I%20will%20double%20check%20and%20try%20to%20write%20a%20blog%20post%20later%20next%20week%20about%20this.%3C%2FP%3E%3CP%3EI%20know%20some%20customers%20were%20using%20this%20solution%20to%20Update%20customer%20user%20properties%20but%20I%20don't%20know%20if%20it's%20still%20necessary%20with%20the%20last%20version%20of%20Azure%20AD%20Connect.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FOfficeDev%2FPnP%2Ftree%2Fmaster%2FSamples%2FCore.BulkUserProfileUpdater%23user-profile-bulk-property-updater%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2FOfficeDev%2FPnP%2Ftree%2Fmaster%2FSamples%2FCore.BulkUserProfileUpdater%23user-profile-bulk-property-updater%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-30871%22%20slang%3D%22en-US%22%3ERe%3A%20Sync%20Custom%20Active%20Directory%20Attributes%20with%20SharePoint%20Online%20User%20Profiles%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-30871%22%20slang%3D%22en-US%22%3E%3CP%3EThere%20is%20an%20API%20Service%20that%20you%20can%20use%20to%20do%20bulk%20upload%20of%20attributes%20that%20don't%20match%20the%20AD%20Sync%20to%20Office%20365.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdev.office.com%2Fblogs%2Fintroducing-bulk-upa-custom-profile-properties-update-api%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CFONT%20color%3D%22%230563c1%22%20face%3D%22Calibri%22%3Ehttps%3A%2F%2Fdev.office.com%2Fblogs%2Fintroducing-bulk-upa-custom-profile-properties-update-api%3C%2FFONT%3E%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-30868%22%20slang%3D%22en-US%22%3ERe%3A%20Sync%20Custom%20Active%20Directory%20Attributes%20with%20SharePoint%20Online%20User%20Profiles%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-30868%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F637%22%20target%3D%22_blank%22%3E%40Brent%20Ellis%3C%2FA%3E%26nbsp%3Bthanks%20for%20the%20response.%20I%20would%20like%20to%20try%20an%20avoid%20the%20%22Audiences%22%20as%20this%20solution%20will%20be%20in%20SharePoint%20Online%20and%20my%20experience%20with%20Audiences%20in%20SP%20Online%20is%20that%20they%20take%20for%20ever%20to%20compile%20and%20there%20is%20no%20way%20to%20manually%20compile%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETherefore%20going%20down%20the%20Search%20path%20and%20utilising%20search%20queries%20to%20match%20values%20in%20User%20Profile%20Properties%20with%20%22tags%22%20added%20to%20content.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20I%20will%20go%20down%20the%20PowerShell%20path%20and%20get%20the%20security%20groups%20(as%20this%20is%20an%20accurate%20representation%20of%20what%20%22teams%22%26nbsp%3Bthe%20user%20belongs)%20and%20populate%20a%20custom%20multi%20valued%20SharePoint%20User%20Profile%20Property.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGood%20approach%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-30768%22%20slang%3D%22en-US%22%3ERe%3A%20Sync%20Custom%20Active%20Directory%20Attributes%20with%20SharePoint%20Online%20User%20Profiles%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-30768%22%20slang%3D%22en-US%22%3EWe%20use%20a%20powershell%20script%20to%20populate%20custom%20sharepoint%20user%20profile%20properties.%20You%20could%20create%20a%20multiple%20value%2C%20or%20even%20a%20regular%20string%20field%20with%20a%20value%20like%20CustomDepartment%20equals%20%22HR%20Department%3BIT%20Department%22%3CBR%20%2F%3E%3CBR%20%2F%3EThen%20set%20up%20your%20%22Audiences%22%20rule%20to%20populate%20based%20on%20a%20name%20of%20IT%20Department%20Audience%20where%20the%20rule%20is%20field%20CustomDepartment%20%22contains%22%20%22IT%20Department%22%3C%2FLINGO-BODY%3E
Highlighted
Deleted
Not applicable

I have a requirement from a customer that goes something like this:

 

I need to be able to target content (think Announcements and News). So I am going down the User Profile Properties path and create Site Columns to tag the content and use the Content Search Web Part to rollup the information and match a user property value with the Site Column Value...Easy right.....

 

Now, what if a user is a member of multiple departments let's say but the Department Profile Property only allows for a single value? I can create a new multi valued user property to hold multiple values in there and that should work..

 

Is there a way I can sync a custom Active Directory Attribute of users that hold muliple values with a Custom SharePoint User Profile Property?

 

Has anyone implemented such a thing? 

8 Replies
Highlighted
We use a powershell script to populate custom sharepoint user profile properties. You could create a multiple value, or even a regular string field with a value like CustomDepartment equals "HR Department;IT Department"

Then set up your "Audiences" rule to populate based on a name of IT Department Audience where the rule is field CustomDepartment "contains" "IT Department"
Highlighted

Hi @Brent Ellis thanks for the response. I would like to try an avoid the "Audiences" as this solution will be in SharePoint Online and my experience with Audiences in SP Online is that they take for ever to compile and there is no way to manually compile?

 

Therefore going down the Search path and utilising search queries to match values in User Profile Properties with "tags" added to content.

 

I think I will go down the PowerShell path and get the security groups (as this is an accurate representation of what "teams" the user belongs) and populate a custom multi valued SharePoint User Profile Property.

 

Good approach?

Highlighted

There is an API Service that you can use to do bulk upload of attributes that don't match the AD Sync to Office 365.

 

https://dev.office.com/blogs/introducing-bulk-upa-custom-profile-properties-update-api

 

 

Highlighted

Using the last Azure AD Connect you can push custom AD Attributes to Azure AD and Office 365. Why not using this feature to keep sync a local AD multi valued attributes and using it from SharePoint User Profil to build a new Audience? That should work. I will double check and try to write a blog post later next week about this.

I know some customers were using this solution to Update customer user properties but I don't know if it's still necessary with the last version of Azure AD Connect.

https://github.com/OfficeDev/PnP/tree/master/Samples/Core.BulkUserProfileUpdater#user-profile-bulk-p...

 

Highlighted

Yeah i have heard that the current AAD Connect does custom attributes. i guess i still need to get those custom attributes into a SharePoint Online User Profile. I would like to avoid audiences in SharePoint Online if possible because of the lack of control of compilation schedule, unless that has changed?

 

If i can get these custom attributes synced by aad connect then into sp online that would be ideal.

Highlighted

Hello Guys,

 

Is there any news about SharePoint Online User Profile Sync with AAD Connect custom mapped properties?

 

Let me explain a little, i need some custom properties already mapped on AAD Connect on SharePoint User Profile, on my research i cannot find any way except developing OOB script/EXE to perform this action.

 

Best Regards,

Sergio.

Highlighted

Hi.  I have the same necessity.  I have the custom attribute in AAD.  I need a way to get it over to SharePoint user profile.  Any suggestions?

 

Highlighted

HI Medardo,

 

For now at least, there is no option to sync custom Active Directory attributes with SharePoint Online automatically.

 

I followed the instructions of this article and implemented a console application that do the job. 

 

https://msdn.microsoft.com/en-US/pnp_articles/bulk-user-profile-update-api-for-sharepoint-online

 

Best Regards!

Sergio.