web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Automate
Unanswered

Split Json

(0) ShareShare
ReportReport
Posted on by 204

Hi Guys,

 

I have a collection being sent in Json format to power automate.

The collection has a few columns although I'm interested in the attachment number column

 

I need to split the collection at every 5th attachment.

For example my collection had 8 rows it will split at the 5th attachment number.

 

Leaving one collection with 5 rows and the other with 3.

 

Any help is greatly appreciated.

 

Thanks

Categories:
I have the same question (0)
  • v-liwei-msft Profile Picture
    Microsoft Employee on at

    Hi @christian12 

     

    You can use the function chunk:

    Divide a string or array into equal-sized segments.

    I think this link will help you a lot:

    Power Automate Chunk Function Explained (zeitgeistcode.com)

     

    Best Regards,

    Levi

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 250 Super User 2026 Season 1

#2
Expiscornovus Profile Picture

Expiscornovus 222 Most Valuable Professional

#3
Haque Profile Picture

Haque 174

Last 30 days Overall leaderboard