I have an "Employee" list which contains username and employee no. and there is another list which contains a column that lookups employee no. in Employee list.

The issue is that I want to show only that employee no. in lookup field where username is equal to current username.

How can I do it using Infopath?

Any help would be highly appreciated.


1 Answer 1

  1. Create data connection to source list in infopath form
  2. change column to calculated
  3. Select filed where you want to display employee number
  4. To add value in column, click on fx, then select source list data connection
  5. Add filer, like ABC then show Employee ID

Here are some articles


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.