Forum Discussion

KasperS's avatar
KasperS
Regular Visitor
4 years ago
Solved

How to get specific values from records within a list

Hi   I have a dataset containing information on a lot of systems we use in my organization. Each row equals to one system with the columns being information about a given system. I have a column ca...
Need Help
  • donsvensen's avatar
    donsvensen
    4 years ago

    Hi Kasper 

     

    You can create a function to help you do this

     

    (listToSearch as any, searchFor as text) =>
let
    Source = listToSearch,
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"Ansvarsområde", "Name"}, {"Ansvarsområde", "Name"}),
    #"Filtered Rows" = Table.SelectRows(#"Expanded Column1", each ([Ansvarsområde] = searchFor)),
    Custom1 = Table.ToRecords( #"Filtered Rows")
in
    Custom1

     

    and then invoke that  as a custom function to your table

     

    the function returns all the contacts with the title so by using {0} I only return the first in this case.

     

    /Erik

     

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I tried to reconstruct your situation (if you want a precise answer this is a job you should do) and starting from this I tried to simulate what you ask.
Try using the yourtab query by replacing "Origin" with your real table.