Updating Contacts via M365 / AAD

Joechaptaylor ✭✭✭
edited 04/29/24 in Smartsheet Basics


Is it possible to link to Microsoft 365, or AAD, and pull through contacts for all users automatically?

This way i can type in Jchap and it will come up with my email, or Joe C and it will also populate me for ANY user in the sheet?



  • Monique_Odom_Comcast
    Monique_Odom_Comcast ✭✭✭✭✭✭

    Hello @Joechaptaylor,

    I'm hoping someone with API or Data Table experience can weigh in to see if there's a better option, but I'm thinking Data Shuttle might be useful here. If you can have your user list auto-exported to a Sharepoint or Google Drive, or if you manage your users within a Smartsheet itself, you can use Data Shuttle to automatically add users (email address or name, not both unfortunately) to a contact list dropdown, so that they can be selected from either the sheet or a form.

    If my comment helped you, please help others by marking it as an accepted answer and consider helping me by clicking the 💡Insightful or ❤️Awesome buttons below!

    Monique Odom

    Business Process Excellence Manager

    Smartsheet Leader & Community Champion

    Pronouns: She/Her (What’s this?)

    “Take chances, make mistakes, get messy!” – Ms. Frizzle