Customer experience | Sales, Customer Insights,...

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

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!

I have the same question (0)

All responses (5)

Answers (0)

Community Member on at

Like (0)

Report
Copy link

Link copied!

Skip token value is always blank.

Was this reply helpful? Yes No
Suggested answer

Bipin D365 28,985 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

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

softchief.com/.../

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
PHemingway610 2 on at

Like (0)

Report
Copy link

Link copied!

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).

Was this reply helpful? Yes No
Suggested answer

syd1 2 on at

Like (0)

Report
Copy link

Link copied!
@PHemingway610,

try to decode it twice. So, based on the original code it could be something like:

if ( empty ( outputs('List_accounts')?['body/@odata.nextLink'] ), '', decodeUriComponent ( decodeUriComponent ( last ( split ( uriQuery(outputs('List_accounts')?['body/@odata.nextLink']), 'skiptoken%3D' ) ) ) ) )

Was this reply helpful? Yes No