cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Get tables from a particular Excel worksheets(tab)

In a Flow, we have a template named “Get Tables”  which gives the table names of the entire excel file. We want to get a table only from a particular worksheet(tab) or is there any way to find out table belongs to which excel worksheet.

 
 
 
 
 
 

Get tables.png

 

 

1 REPLY 1
Highlighted
Responsive Resident
Responsive Resident

Hello @ParteekKumar you can use the Excel "Get worksheets" then "Get Tables" actions to output all worksheets and associated tables.

PAUG_ExcelWStables1.png

PAUG_ExcelWStables2.png

Cheers,

Aman

------------------------------------------------------------------------------------------------------
If my post helps you with your problem or answers your question, please mark it Solved or Answered. This helps anyone with similar challenges. If you like my response, please give it a Thumbs Up.
------------------------------------------------------------------------------------------------------

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (14,653)