web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate How to Delete the last...

Power Automate

Answered

How to Delete the last three rows in Power Automate Deskop

(0) Share

Report

Report

Posted on by TTC Super User 2024 Season 1

Hello,

Can someone please help me on how to delete the last three rows in PAD? I've tried everything (-1, -2, and -3) nothing seems to work.

I have other excel file that the delete work, but it does not work on this file. I am wondering why? I am guessing it's because the grand total is not on row 90? This is how I got the file from the customer, but I need PAD to treat it and delete the last 3 rows.

Thank you an advance!

Categories:

Power Automate Desktop

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

CU16071609-1 6,255 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@TTC

Please follow the below approach.
Launching Excel and opening a specific file
Reading data from Excel
Determining the number of rows in Excel data and add one into it for header
Looping to delete rows for three time and delete the last rows each time

Code:

Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Boot\\Invoice.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance Excel.ReadFromExcel.ReadAllCells Instance: ExcelInstance ReadAsText: False FirstLineIsHeader: True RangeValue=> ExcelData SET ExcelRowscount TO ExcelData.RowsCount + 1 LOOP LoopIndex FROM 1 TO 3 STEP 1 Excel.DeleteRow Instance: ExcelInstance Index: ExcelRowscount SET ExcelRowscount TO ExcelRowscount - 1 END

How to copy and paste the above code into your desktop flows?

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀
TTC Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much!

Join the conversation