Showing inside the form the Enum list based on user selection

[baba_sawane]

Hi everyone. I'm facing an issue with my app, let me explain :

Basically, i have a form :

I'm trying to show the user the list of entries of others rows based on his selection, like this: 

My only criteria is this one. 

This is the table i use for the form :

As you can see, I want to show the list of entries with the virtual column "Report_OutputDisplay" which is a list of ref referenced to my "Report_OutputList" column.

This is the formula I use to select the values :

select(QUAL FORM 02[CODE CHANTIER (voir sur le plan de contrôle) :],


  in(QUAL FORM 02[CODE CHANTIER (voir sur le plan de contrôle) :] , [_THISROW].[Report_CODE CHANTIER (voir sur le plan de contrôle) :]),true

)

 And that's my table where the values are located :

Any suggestion is welcomed ! 

[baba_sawane · Accepted solution]

Finally managed to fix it 😭

I added "if(isnotblank([Report_CODE CHANTIER (voir sur le plan de contrôle) :]), " in my formula.

Final :

select(QUAL FORM 02[ControleID],

if(isnotblank([Report_CODE CHANTIER (voir sur le plan de contrôle) :]), 
  in(QUAL FORM 02[CODE CHANTIER (voir sur le plan de contrôle) :] , [_THISROW].[Report_CODE CHANTIER (voir sur le plan de contrôle) :]),true

))