question

JasonP-9381 avatar image
0 Votes"
JasonP-9381 asked JasonP-9381 commented

How to populate cell data from Sharepoint into fields in an email?1

Hello,

I am not a developer, I don't have a CS background, I'm super new to Sharepoint & Outlook.

That said, I'm turning to here to learn how to:

  1. manually execute a command to take data from various fields in SharePoint (i.e. Name, membership number, phone, email, etc.) with one click

  2. and then populate this data into fields in an outlook email template that automatically mails itself out

I learned how to create an email template. I never made fields in an email template but I know it's possible. So there must be some way to send date from specific cells into those fields right? And once those fields are filled put the email auto sends?

If anyone has any guidance, please talk in a way someone without a background make sense of it.

sharepoint-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AllenXu-MSFT avatar image
0 Votes"
AllenXu-MSFT answered JasonP-9381 commented

Hi @JasonP-9381 ,

As per your description, I understand that you want to automaticlly send eamils and populate the email content and metadatas like To,Cc,Subject... with the field values in the SharePoint list, right? You can take the following demos as a reference.

Manually Executing a Flow from SharePoint with Column Formatting
Add an Action Button to a field for sending an Email in SharePoint List/Library using JSON

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.


If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@JasonP-9381,

Is there any update on this thread?

0 Votes 0 ·

Yes the subject and CC but also to do this within the body of the email (once fields are created there)

I will try these demos tomorrow. @AllenXu-MSFT Thank You very very much for taking the time to respond. As someone with little subject knowledge, it's challenging to know how to word my searches in order to find solution.

Thank You
Jay

0 Votes 0 ·