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.
Solved! Go to 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
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
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".
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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
183 | |
51 | |
47 | |
32 | |
32 |
User | Count |
---|---|
266 | |
91 | |
78 | |
68 | |
67 |