Power Query LIKE Query

[curiouspbix0]

Hi PQ geeks,

How do I write the filtered rows filter to pick all files starting with "ABC_" ? More of a like function.

let
Source = SharePoint.Files("https:XYZ", [ApiVersion = 15]),
#"Sorted Rows" = Table.Sort(Source,{{"Name", Order.Descending}}),
#"Filtered Rows" = Table.SelectRows(#"Sorted Rows", each ([Name] = "ABC_01022019.xlsx" or [Name] = "ABC_01022019.xlsx" or [Name] = "ABC_01032019" or [Name] = "ABC_01042019.xlsx"))
in
#"Filtered Rows"

[curiouspbix0 · Accepted solution]

Nevermind..default feature is available