SharePoint List and Outlook Contact list Sync Issue

%3CLINGO-SUB%20id%3D%22lingo-sub-907835%22%20slang%3D%22en-US%22%3ESharePoint%20List%20and%20Outlook%20Contact%20list%20Sync%20Issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-907835%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20tried%20to%20connect%20SharePoint%20online%20Contact%20list%20to%20the%20Outlook%20Contact%20list%20Synchronize.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20SharePoint%20Contact%20list%2C%20we%20removed%20%22Company%20and%20Country%22%20and%20added%20the%20Custom%20fields%20(Lookup%20fields%20for%20picking%20the%20data%20from%20other%20lists).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20SharePoint%20custom%20fields%20mapped%20to%20Outlook%20contact%20list.%20But%20the%20problem%20is%2C%20it%20shows%20the%20%22Value%20ID%22%20also.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F137125i6FEE1DE09C26A3DD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222019-10-11_1209.png%22%20title%3D%222019-10-11_1209.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20to%20remove%20this%20%22ID%22%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-907835%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-909427%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20and%20Outlook%20Contact%20list%20Sync%20Issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-909427%22%20slang%3D%22en-US%22%3ENot%20to%20my%20knowledge.%20The%20sync%20only%20pulls%20the%20text%20values%20across%20and%20lookup%20columns%20values%20include%20that%20as%20part%20of%20it.%20You%20might%20be%20able%20try%20making%20the%20column%20some%20other%20placeholder%20name%20and%20using%20an%20addition%20calculated%20value%20column%20in%20the%20lookup%20list%20named%20Company%20and%20have%20it%20added%20to%20the%20contact%20list%20as%20an%20addition%20column%20from%20that%20list%20or%20see%20if%20you%20can%20reference%20it%20in%20a%20calculated%20column%20named%20company%20in%20the%20contact%20list%20referring%20the%20lookup%20column%20but%20if%20I%20remember%20off%20the%20top%20of%20My%20head%20it%20won%E2%80%99t%20allow%20it.%3C%2FLINGO-BODY%3E
Contributor

We tried to connect SharePoint online Contact list to the Outlook Contact list Synchronize. 

 

In the SharePoint Contact list, we removed "Company and Country" and added the Custom fields (Lookup fields for picking the data from other lists).

 

This SharePoint custom fields mapped to Outlook contact list. But the problem is, it shows the "Value ID" also.

 

2019-10-11_1209.png

 

Is there any way to remove this "ID"?

1 Reply
Not to my knowledge. The sync only pulls the text values across and lookup columns values include that as part of it. You might be able try making the column some other placeholder name and using an addition calculated value column in the lookup list named Company and have it added to the contact list as an addition column from that list or see if you can reference it in a calculated column named company in the contact list referring the lookup column but if I remember off the top of My head it won’t allow it.