Condition on field to insert in sql from excel

[Manarjomar]

Hi there,

I have a flow to insert in a sql db from excel, so the loop read and insert right, but I have a new field and I need to evaluate it,

ORIGIN EXCEL AND DESTINY SQL:

@Anonymous(equals(items('Aplicar_a_cada_uno')?['IdLocation'], 0),null,items('Aplicar_a_cada_uno')?['IdLocation'])

Some idea?

Thank you.

[PrasadAthalye]

 Are you trying to to check if Excel value is 0 and if not send the value to SQL ?

Are you facing issue with the equation?

[Manarjomar]

Hi @PrasadAthalye 

The issue I have it's "the expression is not correct" or something like that in English.

Really I need to check the value on Excel if is 0.

Thank you.

[PrasadAthalye · Accepted solution]

Got it.

If your excel column is of Number type, use following... You do not need @ symbol in the expression.

if(equals(items('Aplicar_a_cada_uno')?['IdLocation'], 0), null, items('Aplicar_a_cada_uno')?['IdLocation'])

If your excel column is of General\Text type, use following... You do not need @ symbol in the expression.

if(equals(items('Aplicar_a_cada_uno')?['IdLocation'], '0'), null, items('Aplicar_a_cada_uno')?['IdLocation'])

[Manarjomar]

Thank you mate,

Works perfect!!