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 / How to get the length ...
Power Automate
Unanswered

How to get the length of json value in PA?

(0) ShareShare
ReportReport
Posted on by 14

What I am trying to do is to get data from unread outlook emails that has a specific keyword in its title.

 

'Get Emails' resolves this issue. However, the problem is that there is a 25 limits in reading out the emails, but there are actually over 500 emails that need to be retrived.

 

So, what I am trying to do is:

1. Initilize variable as 0 (this will be the count of the length of the output resulted from 'Get Emails')

2. Use 'Do Until' and make it stop when the length of the variable is smaller than 1.

3. Put 'Get Emails' in YES property, and then set read emails with the message ID.

4. Set variable as the length of the output resulted from 'Get Emails'

 

However, I am keep getting an error when setting the variable with the length of the output resulted from 'Get Emails'.

 

Can someone please help me how to resolve this problem?

Thanks in advance!

Categories:
I have the same question (0)
  • vivekpande18 Profile Picture
    894 Super User 2024 Season 1 on at

    Hi @yscx523194 , 

    What are you putting inside length()  expression? 

     

    In dynamic content, as an output there might two values

    1. Body

    2. value

     

    You need to value inside length expression to get the count. 

     

    Hope your are doing the same. 

    Paste your expression to check the issue. 

     

    Thanks

    Vivek Pande

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 411

#2
David_MA Profile Picture

David_MA 300 Super User 2026 Season 1

#3
Vish WR Profile Picture

Vish WR 291

Last 30 days Overall leaderboard