List.Generate and iterate dynamic thrue all pagenumbers

[lborget]

Hello, I have a problem with my Power Query.
Hopefully someone can help me with this?

The function (FunctionData) is working correctly for every page i fill in as parameter, but now i want a total list of all available pages. I want to iterate dynamic thrue all pagenumbers, like: https://example.com/test/page=1

But a major drawback is every page give a response back (is available), so i create a big loop with a lot of tables without content, only null values. I can remove all the tables with null values, but i think that's not the best practise.

Thanks!

Let

    DataList = List.Generate( ()=>

[Result= try FunctionData(1) otherwise null, Page =1],

each [Result] <> null,

each [Result= try FunctionData(Page) otherwise null, Page = [Page] +1],

    each [Result]),

    #"Geconverteerd naar tabel" = Table.FromList(DataList, Splitter.SplitByNothing(), null, null, ExtraValues.Error),

    #"Lege rijen verwijderd" = Table.SelectRows(#"Geconverteerd naar tabel", each not List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null})))

in

    #"Lege rijen verwijderd"

[v-shex-msft]

HI @lborget,

In fact, Microsoft already shared some sample codes of specific scenarios in 'helper functions for M extensions'. You can take a look at on it if any sample code meets your requirement.

Helper Functions 

Regards,

Xiaoxin Sheng