I have a question related to lookup data type.
I have 2 tables: employees and insurance. They are linked with through a relationship created in the insurance table. So in the insurance table we have a field called employees which is a lookup data type. I created an app which manages the employees table and I would like to display a page of insurances related to the employee record chosen in the employees pages. I thought I could do it using he lookup field, but I can't.
Everytime I try to use the lookup field I receive the error message like: property expect text value, but this rule produces incompatible record value
how can I do it?
Thanks for posting.
Could you please share more details about the data source?
If the data source here are SharePoint list or Common Data Service, then the Lookup field is considered as record.
To work with this field, we should switch the field as:
For example, in your scenario, assuming the data source is SharePoint list,
after user selection from the Employee gallery, and you would have the insurance filtered by the Employee selected, then the formula under the items property of insurance gallery should be: