web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to create table in...
Power Automate
Unanswered

How to create table in different worksheets?

(0) ShareShare
ReportReport
Posted on by 29

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....

 

Categories:
I have the same question (0)
  • Verified answer
    SunshineK Profile Picture
    102 on at

    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

     

     

     

  • xlzs Profile Picture
    29 on at

    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 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard