Upload Multiple Files and Add Week number - Power Query

[Skybluekid]

Hi everyone,

I have a sharepoint folder, which holds Excel files produced week, so they are named Week 1, Week 2, and so on. I would like to upload using the get Files from Folder option. The problem is the data on the sheets. On the sheets there is no Dates so I am not able to label up which week is which. Is there a way in Powery query to insert a column to show the week which the data relates to.

Thanks in advance.

 

[jdellasala]

I'm not familiar enough with PQ and SharePoint to know whether or not you can pull in a SharePoint folder the same way you can a local folder, and have no way to try it. If you can, you can get a list of the files in the folder complete with their Accessed, Modified, and Created dates/times.