Forum Discussion
Solved
Excel import not consistently recognising blank first column
Hi there, I have a Gen 2 Flow which imports lots of identical excel workbooks in a folder. Column A in all of them is blank - but I'm getting errors as sometimes the Gen 2 Flow imports this first bla...
Thanks - I tried setting InferSheetDimensions to false but you're right it still uses excel's used range. I don't have control over the file creation unfortunately but I can interfere if a file is recieved and breaks the flow. A bit faffy - hopefully a feature to control the import is added soon. Thanks!
Ah it was already true, I thought that was the default? It seems like neither way changes it regardless unfortunately.
Ehren
Microsoft Employee
Microsoft EmployeeOk. Then your best bet would be to write logic in M that detects whether the data starts in Column1 vs. Column2, and handles both cases.