reference field to the table on Service portal form not showing data

[Fraggle Rock]

We have a request form that sits on our service portal. One of the fields on the form user select is a reference field to the table core_company ~ but unless the user completing the form has the role “ITIL” the form does not display anything in the field “Which ITP do they study with”.

Our standard users do not have any roles, but do have a account in SNow to authenticate with SSO and only access ServiceNow through the Service Portal. I am looking for a way to allow our standard users to use the form.

user with ITIL role

User with no role

[Abhay Kumar1]

@Fraggle Rock This issue is sure related to read access access on the table uses to fetch data in that drop down, so it can be either ACL or Query BR.

So verify both to solve your issue 

[Fraggle Rock]

sorry i am more of a configurator this a coder are you able to provide more details 

[AshishKM]

If you have admin access on instance then try to check all read ACL record for associated role.

Use the below URL for that data. Just replace the "<InstanceName>" with dev instance name and check the output.

https://<InstanceName>.service-now.com/sys_security_acl_list.do?sysparm_query=name%3Dcore_company%5Eoperation%3Dread&sysparm_view= 

Page will show the result like below.

Open each record and check for attached role with it.

[AshishKM]

Hi @Fraggle Rock , 

Please check all read ACL on core_company table and validate the attached role for non-itil users as suggested by @Abhay Kumar1.

If all end-users do not have any role ( default ) and using the Service Portal only then you can try some work-around, like creating a new role for non-itil user and add that role to read ACL and grant that role to end user.

or create a new read ACL without any role, then it will be apply to all user with/or/without any role. It's up to org policy that this access restriction should implement or not.

-Thanks,
AshishKM