cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ParteekKumar
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
Amanthaper
Super User
Super User

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
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (58,407)