Function to loop through two columns in Power BI Desktop

[PowerBI88]

Hi,

I am trying to build, with no success,  a function in Power query that receives two columns as parameters from a previous query as input and loops through them.

Can you provide me a hint on how to achieve it?

Thank you,

Kind Regards Marta

[amitchandak]

@PowerBI88 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

refer these

https://www.edureka.co/community/37031/looping-in-power-query

https://eriksvensen.wordpress.com/2019/02/28/powerquery-replicate-doing-an-excel-vlookup-in-m/

[PowerBI88]

Thank you for the references, I will give tham a look.

here are the steps that I am trying to achieve:

1) take the following table with the pairs (projectid, teamid) values

2) for each row of the previous table make a reast api call. That is pass these values as parameters to a query that I have already implemented with these value pairs as parameters.

[V-lianl-msft]

Please refer to this blog:

https://exceed.hr/blog/list-generate-and-looping-in-powerquery/ 

[PowerBI88]

thank you for the link. But it did not solve my problem.