Unable to apply condition in Gallery

(0) Share

Report

Posted on by talal_pervaiz_g

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@talal_pervaiz_g

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.

Was this reply helpful? Yes No