How to sent email notification that based on the condition

[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.

[v-litu-msft]

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.

[Azlin]

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

[v-litu-msft]

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.

[Azlin]

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

[yashag2255]

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!

[Azlin]

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

[Azlin]

Hello All,

Can anyone help me on this?

Thank you

Azlin

[yashag2255]

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!

[Azlin]

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

[Azlin]

Hello Everyone,

Can anyone help me on this?

Thank you 🙂

Azlin

[yashag2255]

Hi @Azlin 

You have done most part correct. Here is what you need to change: 

In each of the append to string actions, just manually type the name of the attribute. So for example, in the has attachments condition part, remove everything from the variable right now and simply type Attachments. And the other ones, similarly type the column names. Later on, in the email, just select the variable in the body and then add missing information after that. This will basically add only values that are missing and in the email include the respective text. 

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!

[Azlin]

Hi @yashag2255 ,

Thank you very much for your response. I really appreciate it 😁.

I did follow your advise, ran the test and received the email. However for Condition 2 & 3, i got error "ActionBranchingConditionNotSatisfied".😢 Only for Condition 1 is correct and i didn't get the mentioned error. 

 Please advise if I did any error.

Really appreciate your help.

Thank You.

Azlin

[yashag2255]

Hey @Azlin 

It is not an error. It means that the other attributes that you are checking for null are not actually null and there is some data in it. Can you check and confirm this? 

If does not work, you can use the contains operation instead of the equal to operator in the condition statement. 

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!

[Azlin]

Hiii @yashag2255 

I have double checked, but there is no data in for the attributes. I also tried use contains operation, but i get error as below :

Do you know what steps can i do now 😭

Thank you

Azlin