Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Splitting data into a CSV table with 25 rows of data each

(0) ShareShare
ReportReport
Posted on by

Hello everyone,

I hope you're doing well. I am relatively new to Power Automate and seeking guidance on a task I'm trying to accomplish.

I have a dataset that I need to split into multiple CSV tables, with each table containing a maximum of 25 rows of data. I'm currently using an 'Apply to each' loop to iterate through the data, but I'm unsure about the best approach to create these CSV tables.

 

Could someone please provide guidance or a sample flow that demonstrates how to achieve this task efficiently in Power Automate?Any help or advice would be greatly appreciated.

 

alesturg20_0-1703059399908.png

 

  • Matthy79 Profile Picture
    Matthy79 4,178 on at
    Re: Splitting data into a CSV table with 25 rows of data each

    Use this formula directly in „apply to each“. Inside the apply to each you say „create csv“ with the current item and do with it whatever you want (save it, send it, …)

  • Re: Splitting data into a CSV table with 25 rows of data each

    which action do i include this under?

     

  • Matthy79 Profile Picture
    Matthy79 4,178 on at
    Re: Splitting data into a CSV table with 25 rows of data each

    Hello @Anonymous 


    Use apply to each with “chunk(yourarray, 25)”

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard