Forum Discussion
Solved
Query to create column comparing text value to column in separate table.
I have data in a table 'listData', one of the columns is 'status' which contains one of ~40 text values indicating the status of the record. These may contain any of the following (shortened for ...
- Hello
List.Contains has to be used here. Maybe you are it applying the wrong way.
Here an example how to apply it: List.Contains(staticData[completedStatuses],[status])
Hope it helps
Jimmy
