Hi,
I've a field in oracle if it is empty i need to assign 0 or field value
I tried this if(empty(items('Apply_to_each_8')?['LOCK_ID']),0,items('Apply_to_each_8')?['LOCK_ID'])
but it is not working properly, how to do that?
Solved! Go to Solution.
@{if(empty(item()?['LOCK_ID']),0,int(item()?['LOCK_ID']))}
Done!!!
Hi,
Thanks for the follow up! Hopefully this can be helpful for future communities members.
Regards,
Alex
-------
Community Support Team _ Alex Rezac
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.