cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SumanKoduri
Helper V
Helper V

How to use if else expression for oracle field

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?ifelse.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
SumanKoduri
Helper V
Helper V

@{if(empty(item()?['LOCK_ID']),0,int(item()?['LOCK_ID']))}

 

Done!!!

View solution in original post

2 REPLIES 2
SumanKoduri
Helper V
Helper V

@{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.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,209)