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

[Aditya_hublikar]

Hello @sntech ,

I just want to confirm whether the Accept, Reject, or Ignore response is stored somewhere in a ServiceNow table/field, or whether the user is simply replying to the verification email with one of these options.

If the response is stored in a table/field, you can trigger the integration when the field value changes and then send the response to SharePoint.

If the response is received only as an email reply, you can use an Inbound Email Action to process the user's response and trigger the SharePoint integration.

The second approach would be more appropriate if the users are expected to simply reply to the email with Accept, Reject, or Ignore.

If this helps you then mark it as helpful and accept as solution.

Regards,

Aditya