Forum Discussion

u156531's avatar
u156531
Brass Contributor
Nov 06, 2023

I need to email the contents of column B if column A changed.

My SharePoint page has a Status column. If the Status in column A is changed to "ready"  I need to email the content in Column B to email address in column C . Can someone show me how to perform thi...
SharePoint
Rob_Elliott's avatar
Rob_Elliott
Bronze Contributor

u156531 it's perfectly fine to ask Power Automate questions here although there are fewer Power Automate experts  to answer them. Your flow will need to look similar to my example. The only real difference in your flow is that in your condition you'll need another row for Status is equal to Ready and make sure the condition uses AND.

 

 

 

 

The image below is the same action but just shows you whereto select the Trigger Window tokens:

 

 

 

 

 Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP UK (and classic 1967 Morris Traveller driver)

u156531's avatar
u156531
Brass Contributor
Nov 07, 2023
Rob, Thanks, I used what you presented, and I get an email when anything in the row is changed. How do I limit it to sending an email only when the Status field is changed to "In Progress" ?
  • Rob_Elliott's avatar
    Rob_Elliott
    Bronze Contributor
    Nov 07, 2023

    You'll need to provide a screenshot of your flow for me to work that out. But make sure you've followed my example which only sends the email if the status column has changed.

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User.
    Principal Consultant, SharePoint and Power Platform WSP UK (and classic 1967 Morris Traveller driver)

    • u156531's avatar
      u156531
      Brass Contributor
      Nov 08, 2023
      I believe I have this worked out. Thanks for your help.

Resources