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

Brass Contributor

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

5 Replies
This is a Power Automate question. You may want to try the Power Automate community for an answer.

https://techcommunity.microsoft.com/t5/power-automate/ct-p/PowerAutomate

@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.

 

0-SP.png

 

1-Flow.png

 

2-Flow.png

 

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

99-triggerWindow.png

 

3-Flow.png

 

4-Flow.png

 

5-Email.png

 

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

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" ?

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)

I believe I have this worked out. Thanks for your help.