Forum Discussion

artp's avatar
artp
New Member
3 years ago

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? 

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    It may be a bug, but is it a problem?  All you need is the Content column.

  • artp's avatar
    artp
    New Member
    3 years ago

    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's avatar
      lbendlin
      Super User
      3 years ago

      Every time source data is provided by humans (especially Excel) you have to expect things like this to happen and harden your code accordingly.