Forum Discussion
Powerautomate / sharepoint folder / new item
Hi, thanks a lot for your help. For my model I needed all files in this folder so content column 'Binary' was not useful.
But I have found solution and reason why PowerQuery saw this Excel file as 'Error' (before manually open). And the issue are empty cels in first row of dataset:
As you can see cels C1, D1, (...) are empty so Power query saw only column A and B. At this moment my solution is: I created new flow with opens this file and create table range row 6 and all data below. This helped because all data is visible.
I am not expirenced well but from your perspective is it a casual case that empty cells in Excel can be a issue for Power Query? 🙂
- lbendlin
Super User
Every time source data is provided by humans (especially Excel) you have to expect things like this to happen and harden your code accordingly.
