How to send an email with custom dynamic data based off list columns, upon a List Column update?

Jeffrey Rodgers 1 Reputation point
2021-11-29T10:58:00.387+00:00

I currently have a Flow set up for when an item in a SharePoint list is modified send an email.
The email I currently receive is like this:

Subject:
Item: 122 Edgewood was modified by Jeff

Body:
Item: 122 Edgewood was modified at 2021-11-29T09:42:45Z by Jeff

I would like to customize this email to make it like this:

Subject:
[List Item Title]: [List Column Name] Draw Stage Completed

Body:
Please submit Draw Request for this Project. The [List Column Name] Draw Stage has now been marked complete by [User Name].

or to clean it up, like this...

Subject:
123 Test Lane: Permitting Draw Stage Completed

Body:
Please submit Draw Request for this Project. The Permitting Draw Stage has now been marked complete by Jeff.

Any assistance will be greatly appreciated.

Microsoft 365 and Office | SharePoint | For business | Windows
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Yi Lu_MSFT 17,611 Reputation points
    2021-11-30T03:07:22.117+00:00

    Hi @Jeffrey Rodgers
    You could create a flow like this:

    155604-image.png

    As a result, when you modify the list, you will receive an email like this:

    155575-image.png


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in [our documentation][3] to enable e-mail notifications if you want to receive the related email notification for this thread. [3]: https://learn.microsoft.com/en-us/answers/support/email-notifications


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.