LINKTOFILTEREDVIEW and IN to filter rows containing an enumlist column

[MikeBerte]

Hi there,

Thanks for the many ressources shared here.

Here is my problem : I have two tables "Participants" and "Groups". Groups contains a EnumList column "PeopleOfTheGroup" (refering Participants).

• I have "Joe", "Paul", "Diana" in Participants (column "Name").
• And I have Group1 with "Joe", "Diana" (type EnumList) in the column PeopleOfTheGroup
• And also Group2 with "Joe", "Paul"

I'm first showing  the participants list; after chosing one, the app should go to Groups view filtered with only this participant's groups. For instance :

• When chosing "Joe", see Group1 and Group2
• When choosing "Diana", see Group1 only.

I've set an action on Participants view with this :

LINKTOFILTEREDVIEW("Groups", IN([_THISROW].[Name], [PeopleOfTheGroup]))

And... it's not working.

When testing with a fixed list instead of PeopleOfTheGroup, the filtering is working. So I guess there's something I'm missing with that dynamic filtering of a list.

Any help is welcomed, as I'm struggling with this since a few hours !

Thanks,

Mike.

[Suvrutt_Gurjar]

---

@MikeBerte wrote:

LINKTOFILTEREDVIEW("Groups", IN([_THISROW].[Name], [PeopleOfTheGroup]))

---

Please try 

LINKTOFILTEREDVIEW("Groups", IN([_THISROW].[Name], SPLIT(TEXT(Groups[PeopleOfTheGroup]),",")))