Remove junk row from Excel File outside of table

(1) Share

Report

Posted on by nmeye01

Hello, I am building a fairly simple flow that grabs an Excel file from an email attachment, saves it to OneDrive, creates a dynamic table, and uploads the data to Sharepoint. Unfortunately the create table trigger does not capture the last row of the data, which is mostly a junk row (see attached image), which is causing the subsequent Sharepoint insert to fail unless I manually delete it.

I am uncertain how to use the Delete Rows trigger to delete this junk row as it's outside of a table. Any thoughts? Any help is super appreciated!

DataExample.PNG

All responses (1)

Answers (0)

Michael E. Gernaey 43,407 Super User 2025 Season 1 on at

Like (0)

Report

Re: Remove junk row from Excel File outside of table

Hi @nmeye01

Couple thoughts

1. Create a Script inside the Excel (if you can use this as a template for what's coming in)

2. If you cannot get folks to use the Template, ,then create a template file and store it where-ever the data you get is and then copy the rows into the cleaned up copy and delete or archive the original

3. Add a table around that one row, delete the row, delete the table.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey