News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Delete specific sheet ...

Power Automate - Building Flows

Answered

Delete specific sheet within excel with flow

Like (0) Share

Report

Report

Posted on 23 Mar 2021 13:41:15 by Community Power Pla...

Hello!

Is Flow able to identify sheets in excel and delete the first two sheets and keep the third sheet in the workbook? .

Categories:

Business Process Flows

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

Yutao Huang Microsoft Employee on 23 Mar 2021 at 22:20:52

Like (0)

Report
Re: Delete specific sheet within excel with flow

One possible workaround (though may need a lot more extra effort) is to use an HTTP action to send a request to the Microsoft Graph API to delete the worksheet.

There information might be helpful:
Worksheet: delete - Microsoft Graph v1.0 | Microsoft Docs
Power Automate - Read large Excel files within seconds without creating tables using Microsoft Graph (sharepains.com) (credit: @PieterVeenstra ) - this is to demonstrate how to call Graph API from Power Automate.

Ask me about Office Scripts | Check out my Twitter / GitHub
Community Power Pla... on 23 Mar 2021 at 19:02:29

Like (0)

Report

Re: Delete specific sheet within excel with flow

Thank you but unfortunately office scripts are blocked by my corporation rules..any other solution?
Yutao Huang Microsoft Employee on 23 Mar 2021 at 17:49:04

Like (0)

Report
Re: Delete specific sheet within excel with flow

It might be worth checking out Office Scripts, through which you can write some simple script code to do things like deleting worksheets.

Please check out these articles to learn more about Office Scripts:
Office Scripts in Excel on the web (overview)
Announcing support for Office Scripts in the Excel Online (Business) connector
Run Office Scripts with Power Automate
Call scripts from a manual Power Automate flow
Pass data to scripts in an automatically-run Power Automate flow

And specifically, the worksheet.delete() method:
ExcelScript.Worksheet interface - Office Scripts | Microsoft Docs

Hope this helps!
Yutao
Ask me about Office Scripts | Check out my Twitter / GitHub

Helpful resources

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!

May 7th | Register Today: Understanding Agents- Introductory Session

🌸May 8th | You're Invited: Community Spring Festival Awards Celebration🌸

May 14th | Power Platform Community AMA: Power Apps Edition

Quick Links

Leaderboard > Power Automate - Building Flows

#1

Churchy 6

#2

Chriddle 4 Super User 2025 Season 1

#2

stampcoin 4

Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans