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
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
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
Thanks Jimmy, that's worked.
Whats frustrating is that I would've sworn that's what I tried when I first came across the list.contains function. Clearly not though as this is working where it wasn't before.
Appreciate your help.
