cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

Help with sending email after sharepoint columns are updated

Here is what I am needing to create and I would appreciate anyone's assistance. How can I create a Flow to do the below?

Step 1: A new item is created

            and "Yes" is populated in Column 1 

            Send an email

Step 2: then Column 1 is updated to "Meets"

             and Column 2 equals 123 or 456 - send email

             or if Column 2 does not equal 123 or 456 but DOES equal 678 - send email

Step 3: when Column 3 is updated to "approved or  Denied" - send email  

 

12 REPLIES 12
Highlighted
Dual Super User II
Dual Super User II

Re: Help with sending email after sharepoint columns are updated

  1. Create the Flow to run when an item is created or modified
  2. Use condition statements to move to one of three paths through the flow depending on the conditions of the various columns.

 



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Highlighted
Helper V
Helper V

Re: Help with sending email after sharepoint columns are updated

Can you show me an example as I have not used conditions in Flow yet. Thank you!

Highlighted
Super User III
Super User III

Re: Help with sending email after sharepoint columns are updated

@Tbruns 

I agree with the guidance provided by @Pstork1 but would like to add that you probably want to add a column that says when email has been sent and/or the state of your workflow.  The purpose of this additional column is to guard against multiple emails being sent when an item is updated multiple times.

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Highlighted
Dual Super User II
Dual Super User II

Re: Help with sending email after sharepoint columns are updated

Not a complete solution but the following should get you started.

screenshot.png



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Highlighted
Helper V
Helper V

Re: Help with sending email after sharepoint columns are updated

Each time I try to add a condition it puts it in a "Apply to each" which you do not have on your screen shot. What am I doing wrong?

Highlighted
Helper V
Helper V

Re: Help with sending email after sharepoint columns are updated

Can anyone assist with my question regarding "Apply to All"?

Highlighted
Dual Super User II
Dual Super User II

Re: Help with sending email after sharepoint columns are updated

The Apply to all will be automatically inserted if the column you are access is allowed to have multiple selections. It has to apply the logic to each selection. The columns I used in my screenshot were single line of text.  What kind of column are you trying to key off of?



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Highlighted
Helper V
Helper V

Re: Help with sending email after sharepoint columns are updated

They are choice columns

Highlighted
Dual Super User II
Dual Super User II

Re: Help with sending email after sharepoint columns are updated

You are probably using just the column name.  Since its a choice column it has multiple entries and those entries are complex objects. You need to make sure that you are submitting just one value.  Are you using choicecolumnname.selected.value?  or choicecolumnname.selectedtext?



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Highlighted
Helper V
Helper V

Re: Help with sending email after sharepoint columns are updated

I have no idea how to find that out. Sorry I am fairly new to Flow.

Highlighted
Dual Super User II
Dual Super User II

Re: Help with sending email after sharepoint columns are updated

That means the thing you are testing in the condition isn't just a text field.  Its something that has more than one part, like a collection, an array or a complex object. Are you trying to test a choice field or some other complex item?



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Highlighted
Helper V
Helper V

Re: Help with sending email after sharepoint columns are updated

Am I doing this correctly?

flow.jpg

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (6,755)