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!