Loop through a list and using the values to generate a new table

[Anonymous]

Hello

I'm a newbie in power bi, I am trying to generate a new table using two steps :

1. Retrieving initial data needed for the second step.

I use an api call and get a column with 'Id' as follows. In this example, I only have one but I'm supposed to have a much larger list of just Ids

2. Each one on these Ids will then need to be used individually for another api call : "getItem(Id)". So in this case, getItem(414483025). This will then give me a row for my data

I want in the end to have a table with all the combined rows, how can I achieve that ? I assume I need a function ? 

Thanks a lot!

[lbendlin]

in your table, add a column that calls getitem([Id])  (note the square brackets)

then you can expand that column and grab the fields you need for your final table.