cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Flow sending message when conditional fails

I built a recurring flow that looks in an Excel sheet to find re-certification dates and notify me when the certification should occur 30 days from today. The current set-up I am using is "List rows present in a table" -> Apply to each [the output i'm using is "value" which is a List of items] -> Condition

 

The condition has been giving me trouble from the start, but essentially what it does is take the "Days Until Next Check" column from each row and then the condition is if it is equal to the number 30. Under the "If yes" I am using the "Post a message as the Flow bot to a channel" function for Teams. There is nothing under "If no". I was having trouble when the "Days Until Next Check" was 3-digits, so I ended up converting both arguments into integers using the int() function. I thought this fixed the issue, but I am still having the same issue.

 

Essentially what is happening is I am getting messages sent even when the condition fails. I truly am at a loss for how this could be happening, because when I look through the summary of the run in the "List rows present in a table" outcome I can scroll through and see that it is pulling the correct numbers from the spreadsheet. The numbers listed are not equal to 30, yet I am still getting a message sent in the Teams chat. When I look at the condition, though, the outcome is false and under the message box it says that the condition was not met. I don't know what function is causing this message to send, and would love any ideas for fixing this issue people might have. I also am a bit frustrated because I cannot peek the code on the conditional to see if there is some sort of weird loophole that is causing the messages to send. 

 

**Also, this issue has happened to me with three different rows and I have tried different workarounds that I thought fixed them, but inevitably the issue reappeared with a different row of data.

gfalanga_0-1595262511354.png

an overview of my flow

 

gfalanga_1-1595262621731.png

messages being sent (date is negative because of issue within the sheet, but even so should not be an issue because the message should only send when the number of days is equal to 30)

 

gfalanga_2-1595262709174.png

the days until next check is correctly listed as 255 (and this number appears in the message sent), but there should be no message sent as it is not equal to 30

 

gfalanga_3-1595262786434.png

the most puzzling part in my opinion, is that in all of the cases where these messages are sent to the Teams channel, the condition result is false and it says that this branch is not executed

 

Overall, I am extremely confused and would love some input from others as to what might be happening. I have not been able to find any other posts with people having similar issues, but I also have not really seen people using flows for similar functions as this one. 

1 REPLY 1
Super User
Super User

Hello @Anonymous 

Try to put your two Int expressions from the Condition action into a Compose action (before the Condition), so that you can see what they are and why the comparision in the Condition fails.

Kindly inform us about the result 🙂

Kind regards, John

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (76,193)