web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Remove rows from an ar...

Power Automate

Answered

Remove rows from an array

(0) Share

Report

Report

Posted on by SitterWizard

34

Hello! Sitter Wizard here. Still getting the hang of Power Automate so please do not make fun of me. What expression should I use to remove the rows from an array?

The rows in the red are the ones I would like to remove. They are usually the last 9 or 10 rows.

Thanks in advance!
Sitter Wizard

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Expiscornovus 33,979 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
You can use a couple of collection functions for this. For example the length and take functions.

Below is an example with those functions.

take(variables('RemoveRowsArray'), sub(length(variables('RemoveRowsArray')), 9))

Test result

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, Bluesky profile or Youtube Channel

Was this reply helpful? Yes No
SitterWizard 34 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you Expiscornovus! worked like a charm.

Was this reply helpful? Yes No

Join the conversation