Power Automate

HTTP - Rest Api call returning only first value.

(0) Share

Report

Posted on by CU09011759-0

https://myrestapiurl?preview=false&exec_mode=oneshot&output_mode=json&count=1&search=xxxx%22

output showing first record only.

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

rzaneti 4,249 Super User 2025 Season 2 on at

Like (2)

Report

Hi,

Are you experiencing the same issue when making the request from another tool, like Postman? If yes, there is an error on your request or it is a problem from the server side.

Based on the URL sample provided by you, it looks like you are including a "count" parameter set as 1, which can be causing this issue: https://myrestapiurl/?preview=false&exec_mode=oneshot&output_mode=json&count=1&search=xxxx%22

Try to remove this parameter from the request and check if it keeps returning only the first record.

Let me know if it works for you or if you need any additional help!

-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Accepted Answer.
If this answer helps you in any way, please give it a like.

http://digitalmill.net/
https://www.linkedin.com/in/raphael-haus-zaneti/

Was this reply helpful? Yes No
CU09011759-0 on at

Like (0)

Report

Hello, yes it is working fine in other tools.

Also i tried to remove count and even tried increasing count. but same result.

When i am changing from Json to csv , it showing all records in power platform.

Not sure why it is showing only first record only.

Was this reply helpful? Yes No
rzaneti 4,249 Super User 2025 Season 2 on at

Like (0)

Report

Hi @CU09011759-0,

That's a weird behavior. Are you using the same headers both in Postman and in Power Automate? Are there any additional headers from Postman that are not included in you PA request?

If both requests look exactly the same, could you please provide more details on which service from Entra ID are you trying to access? I will try to replicate a similar request from my end to investigate potential issues.

Was this reply helpful? Yes No