Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
86
Views
Topic starter
Hi, does it work to paste in the dynamic folder path (csv) to the already formatted query? I formatted one query from one of the csv and then later added the dynamic path folder into Advanced Editor. But when I do that I receive an error message. (Attachment 1) 
I did this procedure because i thought i can reuse the formatted query by referencing it.
Could you advise me on if this method works?
OR do I need to first import the dynamic folder path then apply formatting to the data.
Posted : 12/06/2019 7:49 pm
Hi Junko,
Looks like a formula error. The 'Source' line is missing a closing parenthesis.
Source = Folder.Files(Text.Combine({Path[FolderPathColumn]{0} ,"SourceFiles"},"")),
There might be other problems with the code, but it's difficult to tell as I can't see it all.
Mynda
Posted : 12/06/2019 11:58 pm
