Forum Discussion

CliffordAP's avatar
CliffordAP
Helper II
2 years ago
Solved

PowerQuery: Reference a value to use as input for another M query

I have the following object defined in PowerQuery:

I would like to use the value from this object for another M query in another table:

I have tried:
= #"Kept Last Rows"{[#"Folder Path"=filepath,Name= Filename[Name]]}[Content]
= #"Kept Last Rows"{[#"Folder Path"=filepath,Name= Lines.ToText(Filename)]}[Content]

I think I am missing something about this concept.
Any help would be greatly appreciated!
Thank you