Forum Discussion
Consuming paginated reports
Hi everyone. I'm trying consuming a SalesForce query using the function List.Generate, but something isn't working very well. Each request result 3 rows. [done] = When is false this means tha...
Your syntax looks correct. I wrote the expression below to test it out. Try it out in a blank query to confirm. In my case, the expected result contains one list (in the list).
let
query1 = [done = "FALSE", records = {1,2,3}],
query2 = [done = "TRUE", records = {1,2,3}],
Custom1 = List.Generate(()=> [Result = try query1 otherwise null], each [Result][done] = "FALSE", each [Result = try query2 otherwise null], each [Result][records])
in
Custom1
Pat