Answered

How to loop through an array skipping the first two elements with Power Automate?

(0) Share

Report

Posted on by RichardUchytil

173

I'm parsing an email message. This message can contain multiple alert messages. I have found a way to split the html_to_text so I have each alert as a separate array element. However, the text I am splitting on is also earlier in the body so I end up not needing the first two array elements. If there is only one alert I need array element 3, if there are three I need elements 3, 4 & 5. Ultimately the array element data will be inserted into a sql server database.

I'm thinking I need to use an Apply To Each action. The problem is I don't know how many elements there will be, just that I need to skip the first two.

Any ideas how to skip the first two? Thanks!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

RichardUchytil 173 on at

Like (0)

Report
Copy link

Link copied!

Found it! I need to use skip(variables('Array'),2).

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!
@RichardUchytil

Please find below the logic you need to do to skip first 2 items in the array.

1. Initialize a count variable outside of your array

2. Inside the apply to each

1. Add a compose data operation as below

add(variables('count'),1)

2. Set the count variable to the output of the compose operation

3. Add a condition if count = 3 then do your logic , on the yes branch, this will skip the first 2 items in the array

Hope this works for you!

Was this reply helpful? Yes No
RichardUchytil 173 on at

Like (0)

Report
Copy link

Link copied!
I'm sure that works but seems much more complex than what I found. Then again, maybe what I found won't work all the time or is even correct?

I get the email.
Convert the html to text.
Initialize a variable converting the text to an array using split.
In my Apply to each I set the output from previous steps to skip(variable('NumberOfAlerts'),2).
Then for testing added a send email step where I'm sending the CurrentItem.
That worked for me. Is that way bad or wrong? I'm still very new to Power Automate, so could be I'm doing it wrong.

Was this reply helpful? Yes No