Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- let
- GetWorkItemsPages = (ids as list) =>
- let
- Pages = List.Numbers(0, Number.RoundUp(List.Count(ids) /200)),
- #"Convert to Table" = Table.FromList(Pages, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
- #"Split List to CSV" = Table.AddColumn(#"Convert to Table", "Custom", each Text.Combine(List.Transform(List.Range(ids, [Column1]*200, 200), each Text.From(_)), ",")),
- #"Removed Columns" = Table.RemoveColumns(#"Split List to CSV",{"Column1"}),
- Custom = #"Removed Columns"[Custom]
- in
- Custom
- in
- GetWorkItemsPages
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement