Answered

How to create table dynamically for all worksheets

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi, I want to create table dynamically in multiple worksheets. The excel file could have one or multiple worksheets. The number of records are different but the column headers are the same. I know how to create table dynamically from watching the tutorials in Youtube, it works but it only applies to the first or active worksheet in the excel file instead of all worksheets. I even tried using "Get Worksheet" and "Apply to each" actions but it didn't work too. Can somebody help me please?

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

SanmeshG 1,947 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous ,

I have done a test on my side , and it works fine for me. Please follow the steps from the screenshot.

=OFFSET(@{items('Apply_to_each')?['name']}!A1,0,0,SUBTOTAL(103,@{items('Apply_to_each')?['name']}!$A:$A),7)

Here the last digit 7 , indicates the number of columns(Headers) in your excel Sheet.

Hope this helps.

Please give this answer a thumbs up and accept this as a solution , if this solves your problem.

Thanks,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @SanmeshG , thanks for the guide.

I'm not sure why but it still only creates table on one worksheet only. Here's the run details:

Was this reply helpful? Yes No
Verified answer

SanmeshG 1,947 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous ,

I have tried giving the same name to the sheet as that of your sheets.

And I run into the same issue , so it turns out that , the Name cannot contain spaces. So in the compose try to wrap the worksheet Name in single quotes and it works fine.

Please give this a thumbs up if this solves your issue and accept this as a solution.

Thanks,
Sanmesh

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

It works! Thank you so much @SanmeshG, you're a lifesaver!

Was this reply helpful? Yes No