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

send email when two columns in a sharepoint list are YES. am i doing this right?

hi. simple question hopefully.

 

question 1:

 

i have a sharepoint list with around 15 fields. when the below happens, i want it to send an email. i know how to do it with a single column, but for two columns did i do this right by creating ANOTHER COMPOSE?

status = deal closed

DAI = yes (checkbox in sharepoint)

if both above are true, send email

 

Screen Shot 2022-04-19 at 11.24.26 AM.png

 

question 2:

 

how do i write the expression for my checkbox requirement. If DAI is checkboxed, send the email.

 

Screen Shot 2022-04-19 at 11.29.48 AM.png

how do i write 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions

wow! i didn't know that was a feature.

 

please see if my new flow makes sense. a checkmark = TRUE, right? not YES?

and do i need quotations around "Deal Closed"?

 

do i need to put any action for If No? can i leave it blank?

 

Screen Shot 2022-04-19 at 1.58.08 PM.png

View solution in original post

@cchan000 

If Status is a choice column, you need to reference Status Value rather than status in your condition.

It is better to enter true in the expression window rather than as plain text.  True should be all lower case (true).  If you see my screen shot, note the fx before true indicating that it was entered in the expression window.

Other than those two issues, it looks good!

 

 

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

Scott

View solution in original post

7 REPLIES 7
ScottShearer
Super User
Super User

@cchan000 

You are better off using a condition and removing your compose actions - you can easily add multiple conditions.  On the "Yes" side of your condition, add your email action.  Let me know if you need more help.

image.png

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

Scott

wow! i didn't know that was a feature.

 

please see if my new flow makes sense. a checkmark = TRUE, right? not YES?

and do i need quotations around "Deal Closed"?

 

do i need to put any action for If No? can i leave it blank?

 

Screen Shot 2022-04-19 at 1.58.08 PM.png

@cchan000 

If Status is a choice column, you need to reference Status Value rather than status in your condition.

It is better to enter true in the expression window rather than as plain text.  True should be all lower case (true).  If you see my screen shot, note the fx before true indicating that it was entered in the expression window.

Other than those two issues, it looks good!

 

 

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

Scott
cchan000
Helper V
Helper V

so close. i did everything but when i went to sharepoint and edited an entry to "Deal Closed" and checked the DAI box, it didn't trigger the automation. i checked my run history.

 

Screen Shot 2022-04-19 at 3.12.53 PM.png

one more update: i changed the condition to OR (instead of AND) to test each individually. neither of them triggered an action.

@ScottShearer good evening. did you see my follow-up? thanks!

cchan000
Helper V
Helper V

i got it to work! the only difference is instead of item modified as my beginning, it is item created or modified.

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (3,571)