i have a table with 2 columns, "company name"(EnumList) & "Company Key"(text), the user selects "company name" and then "company key" is filled out automatically and the user can't edit it.
--------------------
when both company name and company key was set to "TEXT" it worked using this formula
SELECT(Company table[Company Key], ([Company Name] = [_THISROW].[Company Name]))
-------------------
I wanted to be able to select multiple "company names" have them separated by a comma, and it still pulls the "company key" and list with a comma.
i get 2 errors , one on expression assistant
--Cannot compare Text with List in ([Company Name] = [_THISROW].[Company Name])--
and on the table
--Column 'Company Key' in Table 'Users table_Schema' of Column Type 'Text' has an invalid expression in the Formula field.'=SELECT(Company table[Company Key], ([Company Name] = [_THISROW].[Company Name]))'. Cannot compare Text with List in ([Company Name] = [_THISROW].[Company Name])--
does anyone have suggestions or even if it is possible to have an EnumList match up with another, I'm trying to be able to create a list of company names and it will pull the company key for each automatically
LinkedIn
Twitter
