web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate output statement and i...

Power Automate

Unanswered

output statement and if statment

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

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:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Expiscornovus 33,511 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

Join the conversation