Sending an email only if a user has said 'Yes' to a question

[ConnellP]

Hey all, 

I've got a flow set up to take information from a list and send it in an email. However, the list has two functions and I can only have the emails being sent for one bit of it. For example, I've asked a question with a 'Yes/No' answer. If the user selects 'Yes' I want the flow to approve sending the email, if they've selected 'No' I don't want the flow to do anything. 

How would I do that? I've got it set up currently to automate the email when a new item is created and it then goes to Outlook V2. I know I need to put a Condition in but I'm not 100% sure how to do that, has anyone got any examples? 

Thanks!

[rsaikrishna]

@ConnellP 

You can use Condition action to check if the column value. Based on True or False, you can send the approval email.

Here is the link on using Condition action:

https://docs.microsoft.com/en-us/power-automate/add-condition

If you do not want the flow to trigger at all, then you need to place the condition in the flow's trigger condition.

https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Power-Automate-Trigger-Conditions-...

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

[efialttes]

Hi!

"I've got a flow set up to take information from a list and send it in an email. However, the list has two functions..."

You are talking about a Sharepoint list, right? If so, can you share a screenshot from its current column design?

Thanx!

[ConnellP]

Hey, 

Yes I'm talking about a SharePoint list 🙂 

I'll attach a super basic flow, I've tried doing the formula in the 'When item is created' to filter out to only the 'Yes' answers, and I've added in the 'initialize' option too but the flow just didn't work, it either timed out completely or it'd say something about the properties not being right. 
The column I need to use is called 'Have you been in an Office in the last 72 hours?' - if the person answers yes to this, this is when I want the email to send with the information I insert with the dynamic functions.

If they answer no, I don't want the flow to do anything, just have the record saved as it usually would

[rsaikrishna]

@ConnellP 

Here is a sample:

In your requirement, in the condition action, you need to place the column "Have you been in an Office in the last 72 hours?" is equal to true.

Note: true should be typed in the expression window.

I hope this will be helpful.

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

[rsaikrishna]

@ConnellP 

You can also add a trigger condition for the "When an item is created" trigger. 

Browse the Settings for "When an item is created" trigger by clicking on 3 dots on the top right corner of the trigger. At the end of the box, you will see trigger conditions.

@equals(triggerBody()?['LikeIt'],true)

You can replace LikeIt with your SharePoint list column.

Here is the screen shot of the trigger:

 

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

[efialttes]

Hi!

So the question is... is your Sharepoint column defined as 'Yes/No' column? Or is it of type 'Choice'? Or is it of type 'single line of text'? Other?

https://support.microsoft.com/en-gb/office/list-and-library-column-types-and-options-0d8ddb7b-7dc7-4...

Assuming the answer is 'Yes/No' column, @rsaikrishna suggestions are the right approach. If not, please let us knwo the Column type

Hope this helps