Valid if Condition not working in bot automation

[Neeraj_Malik]

Dear Experts,

I have the following Valid if Condition for a column in Table A

IFS(
[Txn_Type]="Credit", Filter("Txn_Parties", [Control_Receipt] = "Yes"),
[Txn_Type]="Debit", Filter("Txn_Parties", [Control_Payment] = "Yes")
)

which works fine when a record is added with add action from the view. However, if a record is added through bot Add row to Table A from the values of record added in Table B, the same valid if condition is failing.

"Errors": "Error: Perform DataAction 'Add Client/CP Bank Txn to Control Account' failed because Row having key 'SWCNUS24020800337165' in table 'Control_Account_Statement' containing value 'Client' in field 'Txn_Party' failed 'Valid_If' condition",

Will appreciate any help to resolve this issue. @Suvrutt_Gurjar @Steve @LeventK 

[Suvrutt_Gurjar]

Hi @Neeraj_Malik ,

From the error message it appears that there is a value "Client" in the field "Txn_Party". You could check if it is a valid value for that field. And if not you could analyze further as to why that value is getting populated and how you can populate the field with a valid value during teh bot running.

[Neeraj_Malik]

Thanks @Suvrutt_Gurjar the value is very valid that's the reason I had to reach out to experts like you 😊. By the way, I fugured out the issue. Actually, the data type for all the relevant colums in Table Txn_Parties is supposed to be Text based on the configuration I set up. However, one of the those column data type got picked as Yes/No during regenerate schema of that table. It's now working as expected after correcting the data type as Text.

Thanks once again for putting efforts on my reported issue.

[Suvrutt_Gurjar]

Nice to know you got a solution. Thank you for the update.