News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Excel have multiple sh...

Power Automate - Building Flows

Unanswered

Excel have multiple sheets and each sheets having single table.

(0) Share

Report

Report

Posted on by suhasdorge

6

Dear Team,

i need one help when excel is downloaded at given target location with same file name and table name. so that in the flow it remove the table automatically because of static table we define.

so now define dynamic table in the flow.

if excel file having multiple sheets ( Sheets1 to Sheet8) and each sheets having one table. so how retrieve a data from sheet8.

i using expression

outputs('Get_tables')?['body/value'][0]['name']
 
I think this expression is suitable for single sheet in the excel file.
but multiple sheets in the excel which express is suitable.
 

Categories:

Business Process Flows

All responses Img

All responses (0)

Answers Img

Answers (0)

Helpful resources

News and Announcements

Upwork and Microsoft Power Platform Partnership

Welcome to the Power Platform Communities

Check out the New Agent Creator Community

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 566 Super User 2025 Season 1

#2

David_MA 516 Super User 2025 Season 1

#3

stampcoin 492

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans