Forum Discussion

MVCuser's avatar
MVCuser
Brass Contributor
Jan 24, 2022

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

Microsoft Flow
PowerApps
sharepoint
  • SteveKnutson's avatar
    SteveKnutson
    MVP
    Jan 24, 2022
    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
    • MVCuser's avatar
      MVCuser
      Brass Contributor
      Jan 31, 2022
      Hi, 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

Resources