Forum Discussion
Solved
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 t...
Christoffer160 In "Send an Email" action, under "To" field, you can select the people column from SharePoint using dynamic content.
For example:
- Click on "Add dynamic content":
- 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.
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.