M language Document Introspection - "#sections" intrinsic variable and return value filtering

[igaca]

Hi,

I am wondering if anyone knows how to filter the global environment sections returned via call-out of the "#sections" intrinsic variable?

Here's a visual:

I've already tried "Record.FieldValues" functions but doing so results in the same issue - it will not recognize any values type Table, Function, etc. when attempting to filter.  any input is greatly appreciated!

Igor

[ImkeF · Accepted solution]

you can adjust your syntax like this:

= Table.SelectRows(#"Added Custom", each Value.Is([Value], type table))

This will return all rows who contain Tables in the column "Values"

[igaca]

Spot on   Kudos Imke....onto the next hurdle!