How to not send email to the user if is not the condition I wanted from the excel data

[Vivianthic]

Hi 

Anyone can help me..

@abm 

I tried using your youtube process to send email to individual user however, I have some condition that I wish to filter hence if the condition is not fulfil it shouldn't send email to the user.

I can't resolve it after days of researching. It is still sending null email to the user and even if I use condition value from excel it send multiple email to each user..

My condition is if the customer respond: "No" and days of unanswer greater than 7 days from the excel, it should sent email to that particular user and for user which does not have this condition should not receive email at all. Please help

Below is the original step from your youtube video.

[FLMike]

Hello,

It sounds like you need 2 things.

1. First, to filter the Excel data, by the Column where it is set to No or Yes, based on if they have answered or not.

2. Then you need a Condition action to check if there response time is greater than 7 days.

To help you I need a few things

1. I do not see where you do your List Rows from a Table (Excel Action). Can you please show that step.

2. Can you please provide the Name of the columns (the Date and the No/Yes) 

3. With that information I can help you create your Filter (for excel) and the Condition action you need.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[Vivianthic]

Hi @FLMike ,

Thank you for your reply, I appreciate that.

I have change my flow as follow which will send to individual user:-

And the excel list as requested, there are formula already set under "Customer Respond" and "Days of unanswer" column.

For customer respond is = If order sent date and receive date has value, it will return "Yes", if receive date does not have value, it will return with "No"

For Days of unanswer, the formula are if Customer Respond is No, calculate number of days between today's date and order sent date.

So now I am left with if there is no result from the 2 conditions I mentioned above for User A, it should not send email to User A but if there is result for other User B and C, it should be sent individually which now this flow is correct sending to individual user with selected  rows except for null email still sending to User A for example.

Hope to hear from you soon 🙂

[FLMike]

Hi

Great stuff lets finish this off.

I created a simple Table for this explanation

Step 1. First thing you want to do right after the List Rows in a table is add a Filter Array, with the Dynamic List Rows "value" property as the input. and the bottom expression for your filter.

Now this is my Filter Array

Please NOTE the formula below starts with @And it just keeps removing it

(equals(item()?['Customer Respond'], 'No'),greater(int(item()?['Days Unanswered']), 7))

You can see my flow below and it returned 2 rows, which is correct based on my data.

Step 2. Update my filter to make sure it has your column names

Step 3. Update your other actions to use the Body (output) of the Filter Array versus the List rows.

And bingo no more null emails

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[Vivianthic]

Hi @FLMike ,

Thanks for your prompt response.

May I just confirm what is input in your compose?

Because below flow was filter for each User email address so where do I put this?

[FLMike · Accepted solution]

Hello,

From Above

Step 1. First thing you want to do right after the List Rows in a table is add a Filter Array, with the Dynamic List Rows "value"

So you put in right after the list rows.

What this does is PRE_filter the entire Excel to remove all the rows that would have caused you to send a NULL. So its prior to your flow building the Unique Email List.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[Vivianthic]

Hi @FLMike ,

Thanks for the explanation, I am actually quite new to this so I get that you mention I need to replace Body(Output) from the filter Array to the rest instead of using value from the List Rows.

I change from value to Body(Output) in array: Select CS Email Address

I get the result which shows that 2 users should receive the email alert and flow is successful but I didn't receive any email.. Where should I place Body(Output) filter array to?

Below flow, I didn't change to Body(Output) as I try earlier on and I get some error. Did I miss out anything here? Please guide me, thank you 🙂

[Vivianthic]

Hi @FLMike ,

Please ignore above. I just received those email, guess there is a few mins delay. Thank you so much for your guidance and information! I truly appreciate that 🙂