Forum Discussion

Christoffer160's avatar
Christoffer160
Copper Contributor
Sep 13, 2022

Sharepoint list power automate. Send email to form creator with column data.

Hello, I´m trying to figure out a flow for sending an email to a person identified in a column when another text column of the same list item is edited.

 

Shipping request form is filled out with the requirement of entering their Name connected to MS account in a name column. 

 

A text column is left blank for operators to fill out. When the operator fills out the text column, an email with that information is sent to the person ID´d in the name column. 

 

Is this possible?

 

Best regards,

Christoffer

Microsoft Flow
SharePoint
  • ganeshsanap's avatar
    ganeshsanap
    Sep 14, 2022

    Christoffer160 In "Send an Email" action, under "To" field, you can select the people column from SharePoint using dynamic content.

     

    For example: 

    1. Click on "Add dynamic content": 
    2. Then you will be able to select column names from SharePoint like: 

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

  • PamDeGraffenreid's avatar
    PamDeGraffenreid
    MVP
    Sep 13, 2022

    Christoffer160 

    Yes, very possible. 

    • Use the SharePoint 'Item is created or modified' trigger and connect to your list.
    • Add a condition that checks to see if the length of the TextField is greater than 0.
      • If TextField has a value, send the email to the person (Send an Email V2)
      • If not, do nothing.

    A couple of notes

    • If the item is going to continue to be updated, you will send multiple emails.  Add another field (EmailSent: yes/no). Once you send the message, Update SharePoint Item and set EmailSent to Yes. Then you can update the condition to check that the TextField has a value AND that Notification Sent equals no.
    • Once you get it running, you might want to look at using a trigger action (right click on the trigger action, and select Settings) so the flow only runs if the text fields is empty and a notification has been sent. 

     

    • Christoffer160's avatar
      Christoffer160
      Copper Contributor
      Sep 14, 2022

      Thank you for your response! 

      How do I connect the email trigger to send the mail to who is listed in a specific column? This can be different people. 

       

      PamDeGraffenreid 

      • ganeshsanap's avatar
        ganeshsanap
        MVP
        Sep 14, 2022

        Christoffer160 In "Send an Email" action, under "To" field, you can select the people column from SharePoint using dynamic content.

         

        For example: 

        1. Click on "Add dynamic content": 
        2. Then you will be able to select column names from SharePoint like: 

        Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.