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:
@IF(equals(items('Aplicar_a_cada_uno')?['IdLocation'], 0),null,items('Aplicar_a_cada_uno')?['IdLocation'])
Some idea?
Thank you.
Solved! Go to 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'])
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?
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.
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'])
Thank you mate,
Works perfect!!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
30 | |
29 | |
28 | |
20 | |
11 |