Forum Discussion
Power Query: Get File Name
Hi guys, I am a teacher and I teach different subjects with different assessment types. I want to combine all the marks in a single spreadsheet and then process the grades in one go. I am struggli...
You may use not From File->From Workbook connector, but From File->From Folder (or From Sharepoint Folder). Here you may filter on file, take file path and it's name into the variable, expand file content and after that add column with filename from above variable.
Or that could be done automatically with From Folder connector expand content for few filtered files with the same structure.