none
BCS problem :return items identified by this profile property section doesnot show the items in drop down box

    Question

  • hi we have user profile and I set a BCS connection.but  in return items identified by this profile property section it doesnot show the items in drop down box what should I do ?
    Wednesday, April 19, 2017 12:32 PM

All replies

  • Hi maria1368s,

    The Return items identified by this profile property list returns all user profile properties that have a similar data type to the external content type identifier.

    Please check the type of your external content type identifier.

    Best regards,

    Linda Zhang


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

    Thursday, April 20, 2017 5:56 AM
    Moderator
  • thanks  but how can we  change the data type in sharepoint ? for example the personel id is big int in our sql ?how can we change the sharepoint data type to big int
    Friday, April 21, 2017 8:32 AM
  • Hi maria1368,

    We can create a user profile property with big integer type in User profile service.

    Navigate to Central Administration > Manage service applications > User profile service application > Manage User Properties, create a new property with big integer type.

    Best regards,

    Linda Zhang


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

    Tuesday, April 25, 2017 8:43 AM
    Moderator