If Empty Expression with Math Function

[arslanarif]

Good day and thank you for your interest.

We have a business requirement where we want the use a power automate expression to check the value against a field from Get Rows ID. Basically if the field value is empty or it contains a data value, then we want to replace and update the field by ADDING the previously contained data value and another field value. Please let me know you need any further clarification?

Regards,

Sunny

[Rhiassuring]

"if the field value is empty or it contains a data value" - so, in any circumstance, you want to take the action? I feel like maybe a word was left out here, or it was mistyped - do you mean something more specific here?

[arslanarif]

Thank you for your response. 

Yeah I had a feeling that I may have been unclear. Let's try again with a brief background on the flow. The expression is supposed to check whether the field ('crbdd_invoicepaidamount') contains a data value or whether if the field value is empty. This field is on the invoice entity and we are looking to check when partial payments were previously submitted against the invoice:

If yes, then there should be a data value in that field, which we would then want to add up and calculate with another field ('crbdd_PaymentAmount').

If no, then the field should be empty and that's where we are getting expression error when trying to add it to the second field. Ideally, we want the expression to ignore if the field is empty, and calculate the addition with the second field as necessary. Any help would be appreciated.

Regards,

[Rhiassuring]

Ahhh, yes, that does help clarify. Thank you!

I think you can get through this in a single compose - if(empty('crbdd_invoicepaidamount'),'other_field',add('crbdd_invoicepaidamount','other_field'))

(If I'm understanding correctly.) 

Writing that out would be ... "if the CRBDD field is empty, then just put in the Other Field's value; if it's got something in it, then add whatever's in it to the Other Field's value."

Am I on the right track? 

[arslanarif]

Hmm that makes perfect sense in theory; a bit of a correction, the 'other field' is actually a variable so the dynamic output is like this: variables('VarInvoiceAmount')

So I applied the equation as you recommended, their is an additional required parameter in the expression that is missing at the end after 'other_field'. The tooltip prompt says. " 

if(expression: boolean, valueIfTrue: any, valueIfFalse: any) which is a required. 

The value to return if the expression is 'false'. Returns a specified value based on whether the expression resulted in true or false

So currently, this is what I have: 

if(empty('outputs('Get_a_row_by_ID')?['body/crbdd_invoicepaidamount']'),add(outputs('Get_a_row_by_ID')?['body/crbdd_invoicepaidamount'],variables('VarInvoiceAmount')), valueIfFalse: any)

-What do you think valueIfFalse would be? I put '0' and that didn't work. Or maybe I should attempt a different equation together?

Regards,

[Rhiassuring · Accepted solution]

I was typing that formula from memory when I last responded and forgot some syntax, I think...

One question though, are both of your values coming in as numbers or text? If they are numbers, will it show 0 if empty, or just be straight up empty? It looks like your CRBDD is coming in as text. So let's fix up the formula to account for that, I'll handle both as if text...

if(empty(outputs('Get_item')?['body/crbdd_paidinvoiceamount']),variables('VarInvoiceAmount'),add(int(variables('VarInvoiceAmount')),int(outputs('Get_item')?['body/crbdd_paidinvoiceamount'])))

outputs('Get_item')?['body/crbdd_paidinvoiceamount']

in the above is outputs('Get_a_row_by_ID')?['body/crbdd_invoicepaidamount'] for you.

Here's how it looks when it runs: 

If CRBDD = 444 and VarInvoiceAmount is 555, the result is 999. 

If CRBDD = empty and VarInvoiceAmount is 555, the result is 555.

Let me know about the number situation, though.

[arslanarif]

Beautiful! Works Perfectly. Thank you so much for your kind and generous help. God Bless!

Regards,

Sunny