I am using New Responsive Designer and I have a variable with a lookup function that is looking in another list for a value: lookup("Staff List","Initials",[SharePoint Columns].[PSC Initials],"Credentials")
When I have a person in my "Staff List" with "initials" but do not have "Credentials" (the field is empty), the form does not want to save. When I click on the button "Save", nothing happens. I do not have any error message. It just does not want to save what I entered in the form.
If the variable with the lookup function return a value, the form saves with no problem.
I try to test what was returning when there is no "Credentials" with the function isNullOrEmpty(), but it does not work when there is no "Credentials". It is false if "Credental" has value.
What should I do so that my form saves value if the value from a lookup variable does not return a value?
Thanks,
James