Updating Contacts via M365 / AAD

Joechaptaylor

Hi,

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-Stearn

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.