[_thisrow_before].[column_name]<>[_thisrow_after].[column_name] not working in triggering bot

[Utsav_Chhawchha]

Hello everyone, 

I have been trying to get this to work for the last 3 days and have gone through the community Q&A extensively but unable to find the bug in my app.

I am trying to trigger an email notification with a data change > Update only > Condition to check > [_thisrow_before].[credit limit]<>[_thisrow_after].[credit limit]. But now the app is triggering the notification irrespective of whatever changes I make. Also, the subject line of the email also contains the same formula [_thisrow_before].[credit limit]<>[_thisrow_after].[credit limit], which is working fine. But the only problem is that the event is getting triggered if I make any updates to any of the columns in my data and not just the [credit limit] column that I want it to be. 

Have tried to run combinations of [_thisrow_before].[credit limit]<>[credit limit] , [_thisrow_before].[credit limit]<>[_thisrow].[credit limit] as well but none of that works and the flow is triggered on every update to any column. 

Kindly assist! 

[Suvrutt_Gurjar · Accepted solution]

Thank you. In the two examples you have shared screenshots of, is the understanding correct that the first screenshot shows where the credit limit has not changed and the second screenshot has example where it has changed?

If so, please use one of the following conditions for the bot event and test

If the [Credit Limit] is a numeric column such as number, price or decimal:

AND( [_thisrow_before].[credit limit]<>[_thisrow_after].[credit limit], [_thisrow_after].[credit limit]<>0)

If the [Credit Limit] is a non numeric column such as text:

AND( [_thisrow_before].[credit limit]<>[_thisrow_after].[credit limit], ISNOTBLANK([_thisrow_after].[credit limit]))