Hi,
I have 3 tables and they are Table A, Table B and Table C.
Table A has information of A class company such as address, phone number.
Table B has information of B class company such as address, phone number.
Table C has a record of data which is related to both Table A and Table C.
I want to use workflow rule to fire an action when the [Company] column in Table C is added with the name that matches the company name from Table A.
Here is my current expression.
[Company]=
ANY(
SELECT(
Table A[Company Name], [Company Name]=[_ThisRow].[Company]
)
)
The above expression is valid but the test shows that even the name of the company is not listed in Table A, the workflow rule will fire.
LinkedIn
Twitter
