I was trying to get skiptoken from @odata.nextlink in power automate cloud flow , but I cannot find this nextlink field in dataverse output.

(0) Share

Report

Posted on by Community Member Microsoft Employee

I was using xrmtoolbox to check the total number of value I should get from the query, and it shows 252651 records should be returned.

Then I created a cloud flow, cloud flow will only return 5000 records by default, but I want to get all records (252651), I was trying to use skip token but it doesn't work because @odata.nextlink is not in the output of "List Accounts" step, can someone help me find out where is the issue? thank you!

All responses (4)

Answers (0)

PHemingway610 2 on at

Like (0)

Report

I was trying to get skiptoken from @odata.nextlink in power automate cloud flow , but I cannot find this nextlink field in dataverse output.

All the articles say to use 'skiptoken=' as the delineator for the split function. But the URI comes with "skiptoken%3D" and we haven't decoded it yet, so I'm pretty sure it fails to find 'skiptoken=' ... replace with %3D and all of a sudden the skip token variable gets populated. That got me one step further but I still have malformed XML and my loop only runs once and my flow fails. Hope this helps, though (two years late).
Community Member Microsoft Employee on at

Like (0)

Report

RE: I was trying to get skiptoken from @odata.nextlink in power automate cloud flow , but I cannot find this nextlink field in dataverse output.

Hi It doesn't work for me.. the paging cookie is always empty. I cannot find this variable in my List Accounts output.
Suggested answer

Bipin D365 28,964 Super User 2024 Season 1 on at

Like (0)

Report

RE: I was trying to get skiptoken from @odata.nextlink in power automate cloud flow , but I cannot find this nextlink field in dataverse output.

Hi,

Please check below blog to fetch more than 5000 records from power automate

softchief.com/.../
Community Member Microsoft Employee on at

Like (0)

Report

RE: I was trying to get skiptoken from @odata.nextlink in power automate cloud flow , but I cannot find this nextlink field in dataverse output.

Skip token value is always blank.