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 Platform Community / Forums / Power Automate / Length of a json array
Power Automate
Answered

Length of a json array

(0) ShareShare
ReportReport
Posted on by 15

Hi - is there a function that tells you the total items in a json array?

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

    Hi @ RodrigoF,

     

    You could use the length() of workflow definition language to get the length of a json array.

     

    You could refer to link below to learn more details about workflow definition language:

    https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language

     

    I have made a test on my side and I have created a flow as below to get the amount of the items in sharepint list:

    1.png

    The screenshot of the sharepoint list as below:

     2.png

    The flow would run successfully as below:

     3.png

     

    Regards,
    Alice Zhang

  • SkinnyPete Profile Picture
    39 on at

    Thanks Alice, been trying for hours to resolve this exact issue.

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!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 464

#2
Haque Profile Picture

Haque 431

#3
David_MA Profile Picture

David_MA 323 Super User 2026 Season 1

Last 30 days Overall leaderboard