Contact List column updated from Microsoft Dynamics
I am populating a contact list column using the Microsoft Dynamics connector. Even though the contacts are created in the Smartsheet, populating it with the exact name using the connector does not create it as a contact and inserts the name as text.
This means that you cannot use this contact list column in any workflows as it does not send out notifications to those contacts because of the text input. Is there a way to populate the contact list from a connector so it populate as a contact and not as text?
Answers
-
Hi Warren,
To achieve this you will have to import the contacts into the 'My Smartsheet Contacts' of the owner of the Data Shuttle connecter workflow. Once contacts are imported in that users contact book then they will begin to be recognized as full contact cards.
You also have to (in data shuttle) upload the contacts as email values only. In my experience there is no need to include names.
Hope this helps!
Sal
-
Hi Sal,
I'm not currently using Data Shuttle. The Smartsheet is getting populated by the Microsoft Dynamics connector. Are you saying I need to create a data shuttle workflow to find and replace the values in the Smartsheet contact column?
Thanks
Warren
-
Hey @Warren B
I haven't personally tested this with a Dynamics Connector, but my guess here is that the Name can only be recognized as a text value when being input this way.
Try adding values as email addresses (without the Name) to the column. It may not show the display name in Smartsheet, but this should allow automations/notifications to still send out to those emails.
Let us know if this works for you!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives