cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tbruns
Level: Powered On

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
Super User
Super User

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.
Tbruns
Level: Powered On

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!

Super User
Super User

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
Super User
Super User

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.
Tbruns
Level: Powered On

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?

Tbruns
Level: Powered On

Re: Help with sending email after sharepoint columns are updated

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

Super User
Super User

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.
Tbruns
Level: Powered On

Re: Help with sending email after sharepoint columns are updated

They are choice columns

Super User
Super User

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.
Tbruns
Level: Powered On

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.

Super User
Super User

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.
Tbruns
Level: Powered On

Re: Help with sending email after sharepoint columns are updated

Am I doing this correctly?

flow.jpg

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Users Online
Currently online: 98 members 3,728 guests
Please welcome our newest community members: