Rich Data Types - Extract Text
Currently, Rich Data Types can be used in formulae to extract derived data (e.g.: for a Geography data type of a city, say "Seattle", in cell A2, you can use "=A2.[Country/region]" to get a text value of "United States". However, I cannot seem to extract the value itself ("Seattle") into a text string in another cell.
I suggest this because Rich Data Types cannot be imported into Power Query, which while an issue in and of itself, wouldn't be so bad if I could extract the string into another field and import that instead. Alas, I can do neither.
Could this be achieved by having a derived data option like, say, "=A2.[Value]" or something like that?
Thank you for sending Microsoft feedback. Your input is valuable to us and helps improve our products.
You can extract the text “Seattle” to the grid by doing A2.Name.
The Microsoft Team