Displaying Multiple List values based on Selected Enum List Values

Dear Community,
I have a form where I need to display the values of various Descriptions of Work based on the Nature of Work selected which is an Enum List value.
I usually use a Select command for the selection based on the Single Nature of Work value. But, I am stuck with the multiple Nature of Work values & the corresponding Descriptions.

Any help would be greatly appreciated.

Thank you.

Solved Solved
0 4 415
1 ACCEPTED SOLUTION

You could write it like SELECT(TableName[Description],IN([Nature of Work],[_THISROW].[Nature of Work]))

View solution in original post

4 REPLIES 4
Top Labels in this Space