Store email responses on sharepoint

[sntech]

Hi,

We have a requirement that a team wants to send a verification email to their users with some options i.e. A.accept, B.reject, C.Ignore. Users will select one of these options and will reply. That Team wants to store these replies on sharepoint. 

Can anyone please suggest what may be the good approach to achieve this?

Thank you.

[OlaN]

Hi,

It sounds like you should have an integration towards your sharepoint.

Basically the trigger would be some answer is changed/stored on the SN instance, and then it would send the needed data to Sharepoint.

[vaishali231]

Hey @sntech 

I would recommend using ServiceNow as the source system and integrating it with SharePoint through REST APIs.

Steps 

1. Capture the user’s Accept / Reject / Ignore response in ServiceNow using an Inbound Email Action.
2. Store the response on the corresponding ServiceNow record.
3. Trigger an Outbound REST Message from ServiceNow.
4. Use OAuth 2.0 for authentication.
5. Call the SharePoint / Microsoft Graph API.
6. Create or update the corresponding SharePoint List item with the verification result.

Flow:
ServiceNow → Verification Email → User Response → Inbound Email Action → ServiceNow Record → REST API → SharePoint

*************************************************************************************************************************************

If this response helps, please mark it as Accept as Solution and Helpful.

Doing so helps others in the community and encourages me to keep contributing.

Regards

Vaishali Singh
Linkedin - https://www.linkedin.com/in/vaishali-singh-2273361bb