cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lsimon7
New Member

If Excel column is FALSE, then send email message

Hello there, I have a form set up with a few True and False questions. I am looking to create a flow that will automatically email someone if any of the four questions they've answered are FALSE, but my flow isn't giving any output.image1.png

 

Here's my flow:

image2.png

lsimon7_0-1597159014304.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Jcook
Super User III
Super User III

@lsimon7 

 

Sure, here is a POC:

 

Here is my example form - it is different than yours, mine I will be looking for True values

Jcook_1-1597175574654.png

 

 

Jcook_0-1597175521726.png

 

Using the Get response details, we can grab the answers dynamically

Jcook_2-1597175671255.png

 

Next if your users are using office365 you can easily get their display name using Get user profile, and passing in the Responders Email. And than send your email off

Jcook_3-1597175747813.png

 

 

 

 


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





View solution in original post

15 REPLIES 15
Jcook
Super User III
Super User III

Hello @lsimon7 

 

When you say your flow is not giving any output, what do you mean by that?

 

Is there a run from history you could screenshot?


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





Hey sorry @Jcook , here's the output after I submitted a form response

lsimon7_0-1597159740760.png

 

lsimon7_1-1597159748302.png

 

Jcook
Super User III
Super User III

Hi @lsimon7 

Thanks,

 

What is the columns in Excel formatted to? (The true and false columns)


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





@JcookThey are formatted as General. Should I set them to text?

@JcookI changed the fields to Text, but that doesn't seem to make it work unfortunately  😕

Jcook
Super User III
Super User III

Hi @lsimon7 

 

What happens if you change the condition to Contains. Instead of is equal to


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





 

@JcookI get this error

lsimon7_1-1597168380838.png

 

 

@JcookI did get 9 emails, but I would like to only receive one every time there's a newly submitted response

lsimon7_0-1597168601228.png

 

Jcook
Super User III
Super User III

Hi @lsimon7 


Okay I can help you with that. But I want to understand what did you change in order to get the emails?

 

How have you been triggering the flow? By filling out the form or by using a test/previous run?


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





@Jcook  I changed the format of the true/false columns in Excel, and changed the condition to 'Contains'. I did not change anything else in the Flow. I have been triggering the flow by submitting a new form response, yes.

Jcook
Super User III
Super User III

Hi @lsimon7 

 

Did you want 1 Email with all the people who cannot come in office?

 

Or just 1 email with the 1 person who submitted the form, if this is the option, you may be missing one crucial part, That is the action Get response details from the MS form. Since the List rows in Excel is listing all rows, we would need to know who has submitted the form

 

How are the details from the form being put in excel?

 


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





@Jcook1 email with the 1 person who submitted the form. How would the flow look like for that? Would it be:

When a new response is submitted-->Get Response details-->List rows present in a table-->Apply to each?

Jcook
Super User III
Super User III

@lsimon7 

 

Yes, but why are using the data from excel rather than using the answers to the form?


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





@Jcook I had no idea that was possible! If I want to do that, how would that flow look like? Check to see if any of the answers are false, and if they are, then send an email out

Jcook
Super User III
Super User III

@lsimon7 

 

Sure, here is a POC:

 

Here is my example form - it is different than yours, mine I will be looking for True values

Jcook_1-1597175574654.png

 

 

Jcook_0-1597175521726.png

 

Using the Get response details, we can grab the answers dynamically

Jcook_2-1597175671255.png

 

Next if your users are using office365 you can easily get their display name using Get user profile, and passing in the Responders Email. And than send your email off

Jcook_3-1597175747813.png

 

 

 

 


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





View solution in original post

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Users online (66,071)