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 this in SharePoint.

 

Thanks, Mark

  • 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
      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

        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)

Resources