In power query, how cany pass a list of names, apply a function, then get a separate query for each name passed to the function

Rishi [G] 21 Reputation points
2022-11-23T14:53:29.657+00:00

Hi,

I have an excel file with multiple sheets. I'd like to perform certain transformations on all of them.
I can create one sample transformation query, and create a function out of it. I can pass a list of sheet names to this function. The only way I know how is add column using invoke function.
The output I get is a table, which then I can expand and combine into one table.
What I want instead, is to run the function, for each sheet name, and get a transformed query.
Is that possible?

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,636 questions
0 comments No comments
{count} votes

1 additional answer

Sort by: Most helpful
  1. Rishi [G] 21 Reputation points
    2022-11-23T15:04:24.073+00:00

    Oops.
    Thanks.