I am trying to build a dereference expression between 2 sheets.
- Patient profile (which has “Employer” which is a enumlist due to spellings/reporting) 2) Appointment (which requires “Employer” for reporting purposes)
I have used the expression [PatientID].[Employer] in app formula on Employer in Appointment, but I am getting this error:
The expression is valid but its result type ‘List’ is not one of the expected types: Text
Whats the best way around this?
As I need Employer to be a enumlist.