Skip to main content

Notifications

Power Automate - General Discussion
Answered

Remove rows from an array

Posted on 22 Nov 2024 16:01:10 by 28
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:
  • SitterWizard Profile Picture
    SitterWizard 28 on 25 Nov 2024 at 15:35:45
    Remove rows from an array
    Thank you Expiscornovus! worked like a charm. 
  • Verified answer
    Expiscornovus Profile Picture
    Expiscornovus 30,523 on 23 Nov 2024 at 13:56:06
    Remove rows from an array
    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
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,111

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,795

Leaderboard

Featured topics