Delete specific sheet within excel with flow

Like (0) Share

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 (3)

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