output statement and if statment

(0) Share

Report

Posted on by Community Power Pla...

Greetings,

i have an Excel sheet from which i extract an array. Once i got that array i now need to look at one specific entry of that Array and compare that one entry to a given key. i tried solving that with the if statement and i think i understand how it works but i have no clue how i can get the output statement to give me the wanted entry.

if(equals(outputs('In_Tabelle_vorhandene_Zeilen_auflisten')?['body/value/Sachkontonr.'],12), '12345 , '0')

As you can see i try to compare the Sachkontonr. with 6520 on the row that the array is right now.

Bildschirmfoto 2023-06-06 um 11.30.19.png

Bildschirmfoto 2023-06-06 um 11.31.09.png

Categories:

General topics

I have the same question (0)

All responses (1)

Answers (0)

Expiscornovus 33,480 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous,

I see this update is in a loop. In that case you can also try to refer to the column by using the item function.

Can you try this instead and see if that works?

if(equals(item()?['Sachkontonr.'],12), '12345', '0')

Was this reply helpful? Yes No