cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
xlzs
Frequent Visitor

How to create table in different worksheets?

I have a list [food, drink, transport], and create sheets from the list.

Now I need create table in every sheets.

(create table food in sheet food)

 

but there is no field to select worksheet in action [create table]

How to create the tables?

 

ps:

The first time I submitted it, I wasn't logged in, so I was redirected to the login screen, and at the end of my login, I noticed that my post had disappeared without being sent or saved....

 

1 ACCEPTED SOLUTION

Accepted Solutions
SunshineK
Helper II
Helper II

Hi xlzs, 

 

I am not 100% sure what you require - however guessing you want to create a table in excel worksheet? 

 

In excel - select insert, and select table. 

 

SunshineK_0-1606270998416.png

 

then for instance if you want to create a record in excel from SharePoint List you can do so 🙂

 

Cheers, 
Summer

 

 

 

View solution in original post

2 REPLIES 2
SunshineK
Helper II
Helper II

Hi xlzs, 

 

I am not 100% sure what you require - however guessing you want to create a table in excel worksheet? 

 

In excel - select insert, and select table. 

 

SunshineK_0-1606270998416.png

 

then for instance if you want to create a record in excel from SharePoint List you can do so 🙂

 

Cheers, 
Summer

 

 

 

thank you for your help

 

I have solved this problem.

In the [create table] option, just fill [table range] with a value in sheetName!A1 format.

such as food!A1 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (6,544)