Forum Discussion
igaca
9 years agoHelper III
M language Document Introspection - "#sections" intrinsic variable and return value filtering
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
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"