Forum Discussion

sparvez's avatar
sparvez
Helper I
3 years ago
Solved

Return complete String from multiple columns searched by a susbstring

Hello Altruists,   I am in a complex situation trying to solve for last few days, but see no hope. Can anyone pls help me?   In a table, i have many columns, column numbers are unknown. Only one ...
Need Help
  • ImkeF's avatar
    ImkeF
    3 years ago

    Hi sparvez ,
    great! You can rewrite like so:
    List.First(List.Select(Record.FieldValues(_), (l)=> Text.Contains(Text.Upper(Text.From(l)), "TV")))

     

ImkeF's avatar
ImkeF
Community Champion
3 years ago

Hi sparvez ,
great! You can rewrite like so:
List.First(List.Select(Record.FieldValues(_), (l)=> Text.Contains(Text.Upper(Text.From(l)), "TV")))