Forum

Notifications
Clear all

7.03 Path folder

2 Posts
2 Users
0 Reactions
86 Views
(@dario)
Posts: 2
New Member
Topic starter
 

Hi guys

I have an issue with the lesson 7.03. PowerQuery doesn't recognise my syntax:

let
//Get text or cvs files from a folder
path = Excel.CurrentWorkbook(){[name="PathTable"]}[content],
Source = Folder.Files(Text.Combine({Path[FolderPathColumn]{0} ,"Excel Course with Mynda"}, ""))
in
Source

It says the name 'Path' wasn't recognised. Make sure it's spelled correctly.

In addition, when I write in the editor the content assistant is off.

I'm open to suggestions. Thanks 🙂

 
Posted : 20/05/2023 11:53 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Dario,

Remember, Power Query is case sensitive. You have named the step 'path' lower case and you're referencing it with 'Path' upper case.

Mynda

 
Posted : 20/05/2023 8:47 pm
Share: