Trying to connect a sharepoint list that has a people column. I only see an ID String for that column when trying to select to add to another program. Is there a work around so I can pull the person who is listed in the people column’s name and email?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+6- Zapier Staff
- 3527 replies
Hi
Welcome to the Community.
When integrating a SharePoint list with a people column in Zapier, you'll often see only a user ID rather than full details like name and email. This is because the people column stores complex user objects. Since Zapier doesn't expand these fields natively, a workaround involves using Microsoft Graph API via a "Webhooks by Zapier" step. This lets you fetch the complete user details by querying the people field. You'll need proper authentication and some API knowledge, and it's essential to test your setup to ensure correct data retrieval and mapping.
I hope this helps resolve the issue you're facing. If you have any more questions or need further clarification, feel free to ask.
+11- Community Manager
- 9744 replies
Hi there
Just came across this and wanted to recommend using an API Request action instead of the Webhooks app Jammer mentioned—Webhooks isn’t able to handle OAuth authentication which Microsoft Sharepoint’s API requires, but API Request actions can.
I’m not super familiar with people columns in Sharepoint but if they reference the users present in the Sharepoint account you could potentially use Microsoft's Get a user API documentation here to make a request to their API and retrieve the name and email address for the user based on the ID you give it.
Keep us posted on how you’re getting on, want to make sure you’re all set! 🙂
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.