Applies To: SharePoint On-Prem and SharePoint Online
Issue: Though the Lookup list has items in the Backend site, the lookup column in the portal form is not populating any values.
Possible Cause 1: Check if any filter is configured for the lookup column.
Resolution: Go to Portal Settings, Edit desired list forms, choose the desired form (new/edit), click on “Lookup settings” under “Advanced” section in left hand side panel, edit the desired lookup column, verify the “Cascaded Lookup Settings”. Remove the filter on the lookup column if not needed and check the result. Sample filter condition screenshot below.
Possible Cause 2: User does not have at least read permissions on the lookup list
Resolution: Go to the back end site, open the lookup list –> list settings –> permissions for this list –> grant at least read permissions to the desired group of users.
To validate the user permissions before granting, go to lookup list settings, permissions for this list, open “Permissions” in ribbon, click “Check permissions” and verify the permissions (Sample screenshot below)