Updating Contacts via M365 / AAD
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?
Answers
-
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