
Hi,
I have a Gallery I which i have to validate data from 2 different sharepoint lists. So the condition looks like below
If(User().FullName in 'Induction Managers Time Selection'.Title && ThisItem.'Employee Name'.DisplayName in 'Induction Managers Time Selection'.EmployeeName && ThisItem.JoiningDate in 'Induction Managers Time Selection'.JoiningDate, Green, Yellow)
In above condition marked in Red giving error that cant convert this data type as I want to validate if the person in ThisItem.'Employee Name'.DisplayName is available in 'Induction Managers Time Selection'.EmployeeName mark green along with additional 2 conditions which are working fine.
Please try the following,
IsEmpty(Filter('Induction Managers Time Selection', User().FullName in Title &&
ThisItem.'Employee Name'.DisplayName in EmployeeName &&
ThisItem.JoiningDate in JoiningDate
), Yellow, Green
)
Please remember to give a 👍 and accept my solution as it will help others in the future.