Forum Discussion
CliffordAP
2 years agoHelper II
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
Name=Filename[Name]{0}
2 Replies
- wdx223_DanielCommunity Champion
Name=Filename[Name]{0}
- CliffordAPHelper II
Thank you!