Hi
I am trying to build a dereference expression between 2 sheets.
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.
TIA
Hi @geoff_gardener,Since your Employer field in the parent table is enumlist type(that, by definition of enumlist can have more than one value of employer) , please define the corresponding dereference field Employer in Appointment table also as enumlist type with same dereference expression of [PatientID].[Employer]
Alternatively, if there can be only one employer for a patient, then you can define the field employer as an enum field in the parent table. In this case, the corresponding dereference field employer in the child
table Appointment can be text type with same dereference expression of [PatientID].[Employer]
User | Count |
---|---|
60 | |
25 | |
13 | |
11 | |
6 |