Forum Discussion
Helper IIExpanding multiple SharePoint people columns is very slow
Hi jsangerman ,
Based on your description, first of all on how to load the user information list separately, I checked some documentation on how to access the SharePoint user information list by navigating to “/_catalogs/users/simple.aspx” from your site via your browser. This assumes you are a SharePoint administrator.
SharePoint User Information List (Hidden List) - Enjoy SharePoint
Use the REST API to get the data in the user information list. The example is as follows:
GET https://<your-sharepoint-site>/_api/web/siteusers
This will return information about all users, including user IDs, logins, emails, and more.
If you don't want to load a list of user information, you can try building a correlation table for lookups and links based on the “_attributename_value” field as mentioned in the following post, instead of “expanding” the attributes in the record.Solved: Refresh very slow when using SharePoint people pic... - Microsoft Fabric Community
Best regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi jsangerman ,
Based on your description, first of all on how to load the user information list separately, I checked some documentation on how to access the SharePoint user information list by navigating to “/_catalogs/users/simple.aspx” from your site via your browser. This assumes you are a SharePoint administrator.
SharePoint User Information List (Hidden List) - Enjoy SharePoint
Use the REST API to get the data in the user information list. The example is as follows:
GET https://<your-sharepoint-site>/_api/web/siteusers
This will return information about all users, including user IDs, logins, emails, and more.
If you don't want to load a list of user information, you can try building a correlation table for lookups and links based on the “_attributename_value” field as mentioned in the following post, instead of “expanding” the attributes in the record.
Solved: Refresh very slow when using SharePoint people pic... - Microsoft Fabric Community
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Helper IIThat is exactly what I was looking for. Unfortunately, I'm not a SharePoint admin, so I can't access it.
I guess there's no other way to do this but to expand those records, which is unfortunate.