User Information List from SP

[shuhn1229]

Hi,

I am trying to import user images from a people picker column on a sharepoint list, lets say that list is called "user access". I was able to ID the hidden "User Information List" Column linked to "user access" and map the relationship between "user information list" and "user access" to get the Picture URLs I'd like to display. This picture URL column works fine for myself and displays an image when I publish the dashboard to web. However, when an end user views the dashboard they get a broken link. I've ensured the end users have viewing privledges to "user access". Any ideas what might be causing this?

Thanks

[rubayatyasmin]

Hi, @shuhn1229 

If your end users are seeing a broken link, it could be due to a few possible issues:

1. SharePoint Permissions: Although you have given end users viewing privileges to the "User Access" list, the SharePoint permissions also need to be correctly configured for the "User Information List" and the location where the pictures are stored. If these permissions are not set up correctly, users might not be able to access the image URLs, which could lead to the broken link issue.

2. Picture Storage Location: The pictures must be stored in a location that all users can access. If they are stored in a location that only certain users have access to (such as your personal OneDrive or a restricted SharePoint library), users without the necessary access rights will not be able to view the pictures.

3. Browser cache or compatibility issue: Sometimes, a browser cache or compatibility issue can lead to broken links. Try to clear your browser cache or use a different browser to check if the problem still exists.

[shuhn1229]

Hi,

Can you comment on how to share the user information list table? As far as I can tell it cannot be shared. Extension is _catalogs/users/detail.aspx.

Thanks

[rubayatyasmin · Accepted solution]

You are correct that the "User Information List" in SharePoint, which has the file extension "_catalogs/users/detail.aspx," cannot be directly shared with users or accessed like a regular list. The "User Information List" is a system list that stores user-related information for the SharePoint site.

Instead of sharing the "User Information List" directly, you can utilize the SharePoint API or other methods to retrieve the required user information and incorporate it into your custom solution or application. The SharePoint API allows you to programmatically access user information from the "User Information List" or any other list in SharePoint.

Here's a overview of how you can retrieve user information using the SharePoint API:

1. Obtain the user's ID or username from your "User Access" list.
2. Use the SharePoint API, such as the SharePoint REST API or Microsoft Graph API, to query the "User Information List" using the user's ID or username.
3. Retrieve the desired user information, such as the picture URL, from the API response.
4. Display the user's picture URL in your dashboard or application using the retrieved data.

[shuhn1229]

Could you elaborate on how I might pull all portraits on my list using GRAPH API? I feel like It would be a huge amount of work involving a blank query.

[rubayatyasmin]

this thread should help. 

https://stackoverflow.com/questions/52369708/getting-image-from-sharepoint-post-with-microsoft-graph

https://learn.microsoft.com/en-us/answers/questions/926543/how-to-get-sharepoint-images

https://www.linkedin.com/pulse/how-upload-file-via-graph-api-sharepoint-satheesh-kumar/

https://medium.com/medialesson/using-the-new-sharepoint-image-column-type-with-the-microsoft-graph-2...