This should be a quick solve for you M fans out there. How do you extract the actual values from Value.Type()? When I apply this, I get the following, which is neither expandable nor extractable.
I ultimately was able to extract the correct values with this brute force mess, but there’s got to be an easier way, right?
Bingo! Exactly what I was looking for. I knew there had to be a function for this - I’ve gotten pretty good at the M function Google scavenger hunt, but never would have found this one (I was sure it would be somehow associated with Type. or .Type).