Forum Discussion

nishi's avatar
nishi
Frequent Visitor
3 years ago
Solved

Text from a specific row based on codintion

Hi,   I have a static table where I will manage Sharepoint URL's for multiple files, i.e:   Table = Environment File URL HML FileA .../sharepoint/HML/FileA.xlsx PRD FileA .../shar...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    3 years ago

    Hi nishi 

     

    This will return text rather than a table

     

     

    = Table.SelectColumns(Table.SelectRows(Table, each [Environment] = Parameter and [File] = "FileA"), "URL")[URL]{0}

     

     

    The way this works is that I've added [URL]{0} to the end of the line.

     

    [URL] extracts the column called URL from the table.  This column is a list.

     

    {0} extracts the first item in that list, the URL that you want.

     

    regards

     

    Phil

PhilipTreacy's avatar
PhilipTreacy
Super User
3 years ago

Hi nishi 

 

This will return text rather than a table

 

 

= Table.SelectColumns(Table.SelectRows(Table, each [Environment] = Parameter and [File] = "FileA"), "URL")[URL]{0}

 

 

The way this works is that I've added [URL]{0} to the end of the line.

 

[URL] extracts the column called URL from the table.  This column is a list.

 

{0} extracts the first item in that list, the URL that you want.

 

regards

 

Phil