Power Query .SelectRows filter based on a list

Question

I had a query and filter on the column for another table

let
    Source = Salesforce.Data("https://login.salesforce.com/", [CreateNavigationProperties=true]),
    MyCustomObject = Source{[Name="MyCustomObject "]}[Data],
    accnt = Source{[Name="Account"]}[Data],
    accntId = Table.SelectColumns(accnt, {"Id"}),
    accntList = Table.ToList(accntId, Combiner.CombineTextByDelimiter(",")),
    #"Filtered" =  Table.SelectRows(MyCustomObject, each List.Contains(accntList, [AccountId__c]))

 in 
    #"Filtered"

How can I do this? 

Answer 1

Transform this particular line:

accntList = List.Distinct(accnt[Id]),

code will look like this:

let
    Source = Salesforce.Data("https://login.salesforce.com/", [CreateNavigationProperties=true]),
    MyCustomObject = Source{[Name="MyCustomObject "]}[Data],
    accnt = Source{[Name="Account"]}[Data],
    accntList = List.Distinct(accnt[Id]),
    #"Filtered" =  Table.SelectRows(MyCustomObject, each List.Contains(accntList, [AccountId__c]))

 in  

    #"Filtered" 

If u want to learn the tool in depth, then come to us and sign up for this Power BI course online at Intellipaat.

Answer 2

buying real viagra online <a href="http://llviabest.com/#">viagra. no prescription</a> buy viagra in sydney [url=http://llviabest.com/]viagra sale[/url] ’

Answer 3

viagra online by paypal <a href="http://genqpviag.com/#">viagra professional scam</a> viagra us overnight mastercard accepted [url=http://genqpviag.com/]viagra gold bestellen[/url] ’