How to sent email notification that based on the condition

(0) Share

Report

Posted on by Azlin

Hello All,

I am currently working on a task to sent an email automatically when an important info missing from the share point.

I encounter a problem when doing this project which is the email created cannot detect the condition I setup. I created 3 different condition using an “or” setup and I want an email will be sent only when the condition triggered was equal to “null”, but it doesn’t.

Appreciate your help 🙂

Thank you.

Categories:

Building flows

I have the same question (0)

All responses (14)

Answers (0)

Sort by

v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Azlin,

So, when the columns in the condition are null, will email still send?

Could you please tell me the types of these three columns?

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Azlin 18 on at

Like (0)

Report
Copy link

Link copied!

Hello Lin Tu,

Unfortunately nope, when the condition are null, no email send.
I ran the test with the condition are null, but i didn't received any email with error "Action Branching Condition Not Satisfied"
Types of these 3 columns are string.

Thank you,
Azlin

Was this reply helpful? Yes No
v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Azlin,

OK, what types of the three columns are?

Are they all String - single line of text?

If possible, you could share the screenshot about the output of Get item (please shield key information).

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Azlin 18 on at

Like (0)

Report
Copy link

Link copied!

Dear Lin Tu,

The three columns are in string function which indicate email, name and phone number. It can in single line text or multiple line.

Here is the snapshot of the Get Item:

Snapshot for the email to send once flow is triggered

Thank you.
Azlin

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Azlin

Can you check and confirm the data types of the columns that you are checking for in the condition?

I see that in the condition you have Has Attachments? in a place and for that you need to update the condition for checking with false instead of null.

Also, I see that you are checking for different columns in the condition and then you have different column names in the email action. can you check and confirm this?

And, you can get the output of an action only when that action is completed. Example, you can use Outputs('Condtion') in a next action to see what was the output of a condition.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Azlin 18 on at

Like (0)

Report
Copy link

Link copied!

Hello @yashag2255 ,

I followed your advise by changing the condition for Has Attachment to "False" and it worked. It manage to trigger the email to be sent to the person in charge.
However, I’m having a problem where the email will be triggered even though the condition is not “null”.
The email will trigger all condition and sent the email even though the information needed is filled.
I want Flow to select between 3 condition, which one or two have an unfilled information and pull that specific blank details to ask back the sender to be filled.

For example, let say for condition 1 & condition 3 is equal to null/ false since there is no data in sharepoint, but for condition 2 there is a value for it, I want an email sent to person in charge by informing that there is no value for condition 1 & 3 only.
emailThe condition

Appreciate your advise.

Thank you,
Azlin

Was this reply helpful? Yes No
Azlin 18 on at

Like (0)

Report
Copy link

Link copied!

Hello All,

Can anyone help me on this?

Thank you
Azlin

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Azlin

As you are using an OR condition, Even if one is true, it will trigger the send email action. And you cannot select or identify which condition was met or not met in this case.

To identify each individual field that does not have value, you need to create separate conditions for each of them. One other thing you can do is, create a string variable at the top and then add three different condition statements. In each of them, you can append to string variable (add action to append to string variable) in the yes branch and add the field names manually and then use this string at the end to send an email.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Azlin 18 on at

Like (0)

Report
Copy link

Link copied!

Hello @yashag2255

I did tried your advice, ran the testing and email was sent out to the person in charge.
However, it seems that email did not send based on the condition that I created.
Could you please advise what do you mean by "add the field names manually and then use this string at the end to send an email."

Also, I tried to put "Output" in email, however I get message pop up stated the expression is invalid.

Appreciate your help.

Thank you,
Azlin

Was this reply helpful? Yes No
Azlin 18 on at

Like (0)

Report
Copy link

Link copied!

Hello Everyone,

Can anyone help me on this?

Thank you 🙂
Azlin

Was this reply helpful? Yes No