Forum Discussion
Powerautomate / sharepoint folder / new item
Hi everyone
I have a problem with mix of this three aplication/services:
1. Eveyday I recive mail with excel where is some data, Powerautomate saves this files on Sharepoint folder and this works great
2. I take all files from this folder using PowerQuery and use it in PowerBI
So where is my problem: always when Powerautomate flow saves files in Sharepoint folder new file is marked as 'New Item' and this make sens
but for Powerquery it's a problem becasue for example tool see 10 files as table type in this Sharepoint folder but the New Item is seen as 'Error'. Print screen below:
What is intresting - when I go to the sharepoint folder and just open and close last saved files 'New Item' Powerquery starts to see this file as a table not error.
Do you have any idea what is an issue and how I can resolve my problem?
3 Replies
- lbendlin
Super User
It may be a bug, but is it a problem? All you need is the Content column.
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
Every time source data is provided by humans (especially Excel) you have to expect things like this to happen and harden your code accordingly.
