Forum Discussion

igaca's avatar
igaca
Helper III
9 years ago
Solved

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"

2 Replies

  • ImkeF's avatar
    ImkeF
    Community Champion

    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's avatar
      igaca
      Helper III

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