Power Query Editor / how to read each entry of a table to call API rest to feed another table

Hello,

On Power Query Editor, in a first step, I'm feeding a first table to get all employee ID using OData service call.

In a second step, and still on Power Query Editor, I would like to read this first table in order to use the Employee ID to build a new OData service call and to execute this call to store the result in a second table.

Could you help me to provide me some instructions and hints to fulfill this demand ?

Thanks.

Regards