Concat / Lookup combined

[Anonymous]

Good afternoon,

I cannot get this right, it would be nice to get some help 🙂

I need to get the Ids from different List boxes to pass them later as lists in an API we already are calling in Flow.

Basically, we need to get different ids from different tables separated by commas. For instance, we have a table called "sites" and we can only see the names (not the ids). But when we try to use Filter and selecteditems it is only bringing back 1 id, it doesn't matter how many selected items we have:

LookUp('[LeticiaProduction1].[Sites]',CommunityName = CommunityList.Selected.Result, communityId)

On the other hand, we could bring the names separated by commas:

Concat(CommunityList.SelectedItems,Result&",")

and we presume we need to use both Lookup and Concat somehow, but we cannot get this right.

Can you please support?

Thank you,

[CarlosFigueira]

You should be able to use an expression like the one below for that:

Concat(
    CommunityList.SelectedItems,
    LookUp('[LeticiaProduction1].[Sites]',CommunityName = Result, communityId),
    ",")

If the type of communityId is not text, then you may need to convert it to a text before using it within the Concat function:

Concat(
    CommunityList.SelectedItems,
    Text(LookUp('[LeticiaProduction1].[Sites]',CommunityName = Result, communityId)),
    ",")

Hope this helps!

[v-yutliu-msft · Accepted solution]

Hi @Anonymous ,

Do you want to filter Sites list based on multiple selection of CommunityList?

Please notice that:
if you use lookup function, you could only get the first record that meet the requirement.

What's more, since you need to compare CommunityName with multiple selection of CommunityList, you should use "in" to compare.

Try this formula:

Filter('[LeticiaProduction1].[Sites]',CommunityName in CommunityList.SelectedItems.Result).communityId

If you want the filtered ids display in one label, you could set the label's Text:

Concat(
Filter('[LeticiaProduction1].[Sites]',CommunityName in CommunityList.SelectedItems.Result),communityId&","
)

Best regards,

[Anonymous]

Brilliant, I have used the label's text and it is working properly now.

Thank you so much 🙂