Create table breaking large Excel file

(0) Share

Report

Posted on by MarkSompton

Hi,

I've been trying to use the Create Table function and it's causing my Excel file to break. My Excel file is quite large (about 1,500 rows and columns to AJ) but definitely works correctly before the function is run.

After running the function and opening the Excel, it is fully greyed out and I can't click on anything but if I Ctrl + F I can still find the data that is meant to be in there. The problem is when I try to run a Get Rows of Table function on this file it returns no data.

I can manually create a table within the file with zero issues and I'm able to run the Get Rows function on this manually created table which does return data. I have experimented by creating my own smaller files and running the function which also causes no issues so the problem is somehow caused by the interaction of this file and the Create Table function.

Has anyone encountered anything similar who knows of a good solution? I've tried Googling around but I haven't found anything.

I have the same question (0)

All responses (1)

Answers (0)

MarkSompton 2 on at

Like (0)

Report
Re: Create table breaking large Excel file

Guys, I've done more digging and I think I've isolated the problem.

It doesn't seem to relate to file size, I think it's to do with Windows Defender making it a protected file. My flow is roughly:

Create file from attachment when email received
Create table from file
Get rows from table

This always creates a broken table if I run it as above however if I as a user manually access the file between it being created and converted into a table (just open and close it), it always works fine.

So I need some way to automate whatever is being achieved by me manually accessing it to complete the flow.

Anyone have any ideas?

Was this reply helpful? Yes No