
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.
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:
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?