Check if the automaticReplies is equals to null

[Julien2]

Hello,

I have created a flow that will send approvals email when an item is created in SharePoint.

Before the flow sends the approvals email, I have an action "Get Mail Tips for a mailbox (V2)"  that will get the mail tips of a user, after that, I have added a condition that will check if this user has the Outlook 365 Automatic Replies turned on which means contains a response, it should go to the alternate approval, if it's turned off it should go to the original approval.

The problem is that the condition always returns false and as a result, it always sends an email to the alternate approval knowing that the automatic replies (as part of mail tips) are turned off for this user.

Please have a look at these screenshots:

For both results of the screenshots I mentioned, the condition always returns false.

I am confused about why this problem occurs since the "null" expression check if "automatic replies (as part of mail tips)" is empty?

Can please someone explains in detail and provides an example of the following scenario?

Any help will be greatly appreciated.
Thank you!

[efialttes]

Hi!

On the conflict Condition, try with the following instead

Add the following expression on the left side of your condition:

items('Apply_to_each_11')?['automaticReplies']?['message']

Add the following expression on the Right side:

empty

Use the following operator:

equals

Hope this helps

[Pstork1]

The Out of Office message change sometime last fall.  When I redesigned my checks I sued the following formula to isolate the message and test if it was null.

first(body('Get_mail_tips_for_a_mailbox_(V2)')?['value'])?['automaticReplies']?['message']

[Julien2]

Hello @efialttes ,

Unfortunately, the "empty" expression is not valid, I have tried to select it from the dropdown, and I have tried to type it.
Here is a screenshot:

Thank you!

[Julien2]

Hello @Pstork1 ,

Could you please provide a screenshot of which action I should use this expression?

Looking forward to your response.
Thank you!

[efialttes · Accepted solution]

Hi!
Empty expression not working?
Try with concat('') instead... two single quotes
Not on my laptop, sorry
Hope this helps

[Pstork1]

Here's that section of my flow. I use the formula to create the OOO variable that I then test against Null

[Julien2]

Hello @Pstork1 ,

Thanks for sharing a screenshot.

Unfortunately, the same problem occurs and as a result, the condition always returns false.
Please have a look at these screenshots:



Looking forward to your response.
Thank you!

[Pstork1]

It's been a couple months since I ran mine last.  Let me look at the screenshots and do some testing and I'll let you know.

[v-bacao-msft · Accepted solution]

Hi @Julien2 ,

Please try to leave right parameters of the Conditions blank directly. Like:

Run history:

Best Regards,

[Pstork1]

I went back and re-ran my Flow with Out of Office.  I had to make a change to the condition I was using.  I'm still using this to get the contents of the actual Out Of Office message in a variable or compose.

first(body('Get_mail_tips_for_a_mailbox_(V2)')?['value'])?['automaticReplies']?['message']

Then doing this for the Left side of the Condition

empty(variables('ooo')) 

So this is what it looks like.

I verified that this works for both with and without an Out of Office message.

[Julien2]

Hi @Pstork1 ,

Thank you for sharing an example.

Unfortunately, I cannot use an "empty" expression on my side and it says that "Expression is invalid" it's a bit strange.

I can confirm that using "concat('')" expression as @efialttes mentioned, and as @v-bacao-msft mentioned in the condition has worked as expected.

Thanks again!

[Pstork1]

If it is saying that the expression is invalid then there is something wrong with the syntax, not that you can't use it on the left side of the equation.

[JillSearcy]

@Pstork1 Thank You! This helped me alot! I appreciate the information!