https://community.fabric.microsoft.com/t5/Power-Query/Return-the-match-from-List-ContainsAny/m-p/1292277/highlight/true
Solved: Re: Return the match from List.ContainsAny - Microsoft Fabric Community
Nov 23, 2022 - Hi, Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end. Table: You may create a custom column
the matchmicrosoft fabricsolvedreturn
https://community.fabric.microsoft.com/t5/Power-Query/Return-the-match-from-List-ContainsAny/m-p/1291612/highlight/true
Solved: Re: Return the match from List.ContainsAny - Microsoft Fabric Community
the matchmicrosoft fabricsolvedreturn
https://mongodb.github.io/mongo-csharp-driver/2.13/apidocs/html/M_MongoDB_Driver_Linq_LinqToMongo_ContainsAny__1.htm
LinqToMongo.ContainsAny(TSource) Method
Determines whether a sequence contains any of the specified values.
method
https://community.fabric.microsoft.com/t5/Power-Query/Return-the-match-from-List-ContainsAny/m-p/1314976/highlight/true
Solved: Re: Return the match from List.ContainsAny - Microsoft Fabric Community
Nov 23, 2022 - Great solutions. Thanks for your help
the matchmicrosoft fabricsolvedreturn