I dont understand properly how List.Generate() works

[Anonymous]

let
    my_list = List.Generate(
        ()=>[x=1], // Failr here with: "ExpressionError: The name 'x' wasn't recogniced. Make sure it's spelled correctly."
        each [x]<101,
        each [x=x+1],
        each Number.Round(Number.RandomBetween(1,101),0)
    )
in
    my_list

Im just trying to create a list with length 100 filled with random numbers from 1 to 100. I wanna know why It doesn´t work.

this is the example from the docs I was looking at before:

List.Generate(
    () => [x = 1, y = {}],
    each [x] < 10,
    each [x = List.Count([y]), y = [y] & {x}],
    each [x]
)

You can check that example at (https://learn.microsoft.com/en-us/powerquery-m/list-generate)

[Anonymous]

Thanks a lot

[AntrikshSharma · Accepted solution]

@Anonymous The issue is at the third argument of List.Generate, when incrementing you need to consider that the current iterated value is a record so you need to use each [x= [x]+1 ]

Complete code:

let
    my_list = 
        List.Generate (
            () => [ x = 1 ],                                                                                                                                                                                                                                                                                                                      
            each [x] < 101,
            each [ x = [x] + 1 ],
            each Number.Round ( Number.RandomBetween ( 1, 101 ), 0 )
        )
in
    my_list

If there isn't any other logic that you are going to use in List.Generate then you can also try List.Trasnform

= 
List.Transform ( 
    { 1.. 100 }, 
    each Number.Round ( Number.RandomBetween ( 1, 101 ), 0 ) 
)