Get Text From Named Range in Power Query
Steps:
1. Create Named Range(s)
2. Open Power Query Editor and Create Blank Query
3. Use Excel.CurrentWorkbook() to get table of all named ranges
4. Use Key Match Lookup {[Name = "Name1"] } to get correct record
5. Use [Content] to get table from Content field
6. Use {0} to get record from table
7. Use [Column1] to get named range data
Final Formula:
= Excel.CurrentWorkbook(){[Name = "Name1"]}[Content]{0}[Column1]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Please checkout my book, Power Query M Language Basics Kindle Edition
https://www.amazon.com/dp/B0DM73H3RV
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~