Forum Discussion

poinfrettia's avatar
poinfrettia
Frequent Visitor
1 year ago
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...
dataflow
  • poinfrettia's avatar
    poinfrettia
    1 year ago

    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! 

poinfrettia's avatar
poinfrettia
Frequent Visitor
1 year ago

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! 

Ehren's avatar
Ehren
Icon for Microsoft Employee rankMicrosoft Employee
1 year ago

Can you try setting InferSheetDimensions to true instead of false? The default is false, so setting it to false won't change anything.

  • poinfrettia's avatar
    poinfrettia
    Frequent Visitor
    1 year ago

    Ah it was already true, I thought that was the default? It seems like neither way changes it regardless unfortunately. 

    • Ehren's avatar
      Ehren
      Icon for Microsoft Employee rankMicrosoft Employee
      1 year ago

      Ok. 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.