Using the Concatenating Expression to join fields
Hey everyone,
I have a table called locations. It has three fields, City , State and Country.
In another table called Company Details, I have a field called location. I want to combine the City and State fields from the locations table to create the dropdown values for this field.
I used this expression CONCATENATE(Locations[City], Locations[State]) in the ValidIf but it generated an invalid data constraint error.
What changes would I make for this to work?
Thanks
User | Count |
---|---|
36 | |
34 | |
27 | |
23 | |
18 |