Using the Concatenating Expression to join fi...

[Tyson_Carmichae]

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

[Aleksi_Alkio]

Create a virtual column to your Locations table as CONCATENATE([City],"-",[State]) and then call that column with the Valid_If.

[Tyson_Carmichae]

Works perfectly. Thanks @Aleksi_Alkio

[Aleksi_Alkio]

You’re welcome