Power Platform Community Forum Thread Details

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!

Categories:

Building flows

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