Display the ref output of an enumlist don't show up

It's a virtual column formula that should show the output of an enumlist. 

When I select 1 value, it shows the output as intended.

GFormMLH_2-1670246184036.png

 

When I select two or more values, the output disappear ๐Ÿ˜ฎ

 

GFormMLH_1-1670246133889.png

I tried different formulas but sometimes it don't even show up no matter if I select one or more values. 

The number of rows at the right of the column name does change, so it's a display issue.

I tried : 

filter("Dossier EGC",contains([Nom du fichier], [Documents liรฉs]))

Select(Dossier EGC[Nom du fichier],IN([_THISROW].[Documents liรฉs], Dossier EGC[Nom du fichier]))

(Dossier EGC[Nom du fichier] - unique(Dossier EGC[Nom du fichier] - [Documents liรฉs]))

INTERSECT([Documents liรฉs], Dossier EGC[Nom du fichier])

This is how my list is set up :

GFormMLH_3-1670246376790.png

 

 

 

Solved Solved
0 2 97
1 ACCEPTED SOLUTION

Thanks for the answer, Marc.

Thanks to your reply, I realised that my formula should ref the key column, which was not the case. 

View solution in original post

2 REPLIES 2

How is the Documents liรฉs column defined? Is it an EnumList-Ref to Dossier EGC? If so, your VC expression is as simple as [Documents liรฉs]

Thanks for the answer, Marc.

Thanks to your reply, I realised that my formula should ref the key column, which was not the case. 

Top Labels in this Space