Filter Function No Error But Not Working

[Anonymous]

Hi,

I have some trouble with the Filter function. I have two SharePoint lists. One called General Info which contains general employee infos with a column called EID - DataField = ye5n. The other list called HR which includes assigned tasks for HR department to complete with a column called Employee ID. For each employee, there are multiple tasks. I'm trying to create a filter for tasks based on employee. This is the formula I'm trying to use. There is no error but nothing shows up.

Filter(HR, BrowseGallery1.Selected.ye5n = Employee_x0020_ID)

I really appreciate if someone could help me solve the problem.

Thank you.

[v-monli-msft]

Hi @Anonymous,

What is the column type of the column "Employee ID" in HR list? And what is the column type of the "EID" column in General Info list? 

Regards,

Mona

[Anonymous]

Hi @v-monli-msft,

I used to have the employee ID in HR as "LookUp" but it didn't work. So I now have it as "Single line of text". Both of them are "Single line of text". 

[v-monli-msft · Accepted solution]

Hi @Anonymous,

If both fields are text column type. Then the formula should be:

Filter(HR, DataCardValue1.Text=Employee_x0020_ID)

DataCardValue1 is the label control's name of EID column in General Info gallery.

If "Employee ID" is a lookup column, then the formula should be:

Filter(HR, DataCardValue1.Text=Employee_x0020_ID.Value)

Regards,

Mona

[Anonymous]

Thank you @v-monli-msft! That works out perfectly!