Filter multichoice column

(0) Share

Report

Posted on by douglas_filipe

Hi all.

I have this SharePoint list ('tb_actions')

DS_RESULTADO_CHAVE_C_N from another list ('tb_goals'), is a multichoice lookup column, cause a need N:N relationship

I created a collection with only goals that I wanna see on this screen

When a try to filter tb_acao a received this message:

How can I filter multichoice column ?

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (4)

Answers (0)

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
Hi @douglas_filipe,

I am not totally clear on where this desired result is coming from, however if you want to show the Value, Id and other fields from tb_goals of all the items chosen in your tbActions Lookup column as seperate records, you would need to do something like this - you also need to add the name of the field you are looking up in tb_goals
With( { _Data: Ungroup( tbActions, DS_RESULTADO_CHAVE_C_N ) }, ShowColumns( RenameColumns( AddColumns( _Data, ID2, LookUp( tb_goals, LookedUpFieldName = Value ).ID, DT_ALTO_RES, LookUp( tb_goals, LookedUpFieldName = Value ).DT_ALTO_RES ), Value, DS_RESULTADO_CHAVE_C_N ), DS_RESULTADO_CHAVE_C_N, ID2, DT_ALTO_RES ) ) )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
douglas_filipe 19 on at

Like (0)

Report

What means DT_ALTO_RES in your code ?

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

@douglas_filipe,

It is the second field (date) I can see in your screenshot - I cannot see the full name, so you will need to put that in.

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

Hi @douglas_filipe,

A quick follow-up to see if you received the answer you were looking for or if you need further assistance.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No