Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a List.Generate that returns list rows of 1000 records from a API call. At this moment there is 22082 records in the source table and I want the list generation to stop when all records are received. In this case there should be 23 rows, with only 82 records in the last row. When harcoding it to stop after 24000 records I get a row with null. How can I make this loop to stop when the row is null?
Solved! Go to Solution.
Hi @Dagobert
On line 4, change
each [cursor_position] <= 24000
to
each [WO_list] <> null
This is the loop-continuation condition for List.Generate.
Does this work at your end?
Yes, it works fine, so easy!
Thanks a lot
User | Count |
---|---|
94 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |