Forum Discussion
MVCuser
Jan 24, 2022Brass Contributor
Send an email when Name is added to a certain column in Sharepoint List
Hi!
is it possible to create a flow, that will send an email to the person when the "Assigned to" column (that is created as "person") gets populated with a Name?
Example: list item 1, when created Assigned to is blank, after revision is assigned to one of my colleagues to John's name is added to the Assigned to. I tried using @ but it does not work.
Any thoughts? thank you
- The best thing to do is use the Table references instead of the row-column references. It is both fast and more robust in case the size of the table changes. i did this in answering your other question. So in your example here it would be Table1[people_fully_vaccinated_per_hundred]
What is really nice is that as you type Table1 is will show in the pop up info window and you hit tab to accept it, then hit "[" and the whole list of options for that table will show up and as you type "p" it filters down to 2 options, hit the down arrow to select the one you want and hit tab to accept, and finally type "]" to finish the reference.
3 Replies
Sort By
- In Power Automate create a new "Automated Cloud Flow"
Choose the trigger "When an Item or File is Modified"
Add a Get Item or Get File Properties step (gets all of the metadata values on the item)
Add a condition to see if the 'Assigned To' column has a value
- YES - send email
- NO - end the Flow- MVCuserBrass ContributorHi, Thank you for your feedback, but that does not work, because it means that any change in that item where a person has been assigned is going to trigger that email, even when closing the job.
I tried using the Dynamic content "has Column changed: AssignedTo" but the outcome is the same as just "AssignedTo" not equal to Null.
I tried using ANDs and ORs but cannot make it work either.
All i want is an email when the "AssignedTo" column changes and not when any other column changes- This video might help. I think it is similar to what you are wanting to do
https://www.youtube.com/watch?v=gVRcFeogfKE
I hope this helps π