I'm trying to populate a user ID field on my Nintex form using a list lookup.
I have a list called hr_import that contains a column named EMAIL and a column named ID. I want to pull that ID result into my Nintex form. I already have a named control on my form that's populating email based on the user profile lookup of the requestor who is submitting the form called Requestor_Email.
The formula I tried was: lookup("hr_import, "EMAIL", Requestor_Email, "ID") but it just says "loading" and doesn't return a value.
Any ideas how I might fix this? Thanks!
