Answered

Lookup and Filter

(0) Share

Report

Posted on by amyharkus86

720

I have a field in a form that populates based on the name selected from a drop down in the form, This is linked to sharepoint list and will look up if the first and last name are the same it will provided the employee number, job title and other information kept in this SharePoint list called Employee List

At the moment it works with the following on each text box i am displaying information for, below is for the resource number

LookUp( 
 'Employee List_1', 
 First_Name = ComboBox1_1.Selected.First_Name &&
 Last_Name = ComboBox1_1.Selected.Last_Name
 , Resource_No)

We have added an additional field in the Employee list called Termination Date, I would like to only display if the termination date is Blank or empty.

I have done this on the Full Name field

Filter('Employee List_1', Not(IsBlank(Termination_Date)))

This work but its stopping the search function from working!

Categories:

General Questions

All responses (2)

Answers (1)

WonderSerota 80 on at

Like (0)

Report

Re: Lookup and Filter

To resolve this issue, maybe try modifying the formula to include the condition for the first and last name as well.
Filter('Employee List_1',
First_Name = ComboBox1_1.Selected.First_Name &&
Last_Name = ComboBox1_1.Selected.Last_Name &&
Not(IsBlank(Termination_Date)))
This formula will filter the Employee List based on the selected first and last name from the drop-down list and only display the Termination Date if it is not blank or empty.
Verified answer

SBax 1,348 on at

Like (0)

Report

Re: Lookup and Filter

You could add the additional condition within your lookup:

LookUp(

'Employee List_1',

First_Name = ComboBox1_1.Selected.First_Name &&

Last_Name = ComboBox1_1.Selected.Last_Name && !IsBlank(Termination_Date)

, Resource_No

If you have further columns, that you need to get from the employee, I would recommend setting a context variable to reduce the number of lookups you have