How to create a custom dynamic list for REST API pagination?

Hi bikelley 

Download example PBIX file

This code will create your list

let
    Source = Record.FromList({12958},{"TotalResultCount"}),
    TotalResultCount = Source[TotalResultCount],
    DynamicList = List.Generate(() => 2000, each _ < TotalResultCount, each _ + 2000),
    FinalList = List.Combine({DynamicList, {TotalResultCount}})
in
    FinalList

I've set up a dummy record in the Source step so that I can simulate getting the TotalResultCount.  You can modify this to suit your own query structure.

Regards

Phil

Hi bikelley 

Change the FinalList step to this

FinalList = List.Combine({{1}, DynamicList, {TotalResultCount}})

Regards

Phil