Skip to main content

Hello. I have created two lists in SharePoint Online; one list is the “main” list (...Time Off Form) that contains a field named Name which is a Person or Group field, and the other list is to be used by the main list for a lookup (list name =’s EmpID), and currently only contains a field for EmpID (Single line of text) and Name (the Name field is a Person or Group field). The form I have is attached to the “main” list, and I have created a rule (See screenshot.). If I replace the lookup function with just text, for example “Test” the rule works as expected, filling in the ...ID field with Test, but if I try to use the lookup function nothing displays in the ID field. I do not receive an error.

For the lookup, I believe… I have it setup correctly. As long as the Name field in the main list is not blank then…  “EmpID” is the name of the lookup list. “Name” is the name of the field in the EmpID list that I would like to compare to the Name field in the main list, and I would like the EmpID FIELD value from the EmpID LIST to be the value of the ...ID field in the main list. (In retrospect I could’ve made things easier on all of us with these names; sorry.) Please advise if possible. Thank you in advance.

Hi, I’d start by checking that your lookup function works by itself.  e.g. create a form variable and use the lookup function in that and then display the result in a label control.  If that doesn’t work then there is an issue with the function.

Thank you @Chris_Ben I have tried that, and nothing is returned. I apologize for not including that in my original post. I actually had the variable in the rule initially with the same function in the variable, but through troubleshooting landed at just putting the function in the rule directly. I am wondering if the function cannot be done because of the field type (people picker… Person or Group field(s)). The ID fields are just text fields. I am going to try this function with two text fields, and see if that works. I will report back.

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings