How to Retrieve Favorites marked documents

Question

Hello,

I want to retireve all the favorite marked documents of a user in sharepoint site. I am aware of the My Content Page which will list us all the documents, recent opened, shared and favorite.

My requirement is to get only the favorite documents marked of a user.

Thanks & Regards

Tuhin Paul · Answer

You need to use the SharePoint REST API, Use the user's ID to fetch their favorite documents. You can get the user's ID using the following endpoint: https:// /_api/web/siteusers/getbyemail('user@example.com') Replace with your SharePoint site URL, and 'user@example.com' with the user's email address.

Meena Bisht · Answer

Hello Tuhin, Thank you for your response. However the above end point does not list me the favorite marked documents of a sharepoint site. My Requirement is to fetch all the favorite marked files and show it to the user. SharePoint has provided MyContent Page but this displays all the files and user need to click on favorite to see not something by default. Thanks & Regards

Sigar Dave · Answer

There are couple of ways to do this using PowerShell or Graph API. Use PnP PowerShell to fetch favorite documents from SharePoint. # Connect to SharePoint Connect-PnPOnline -Url https://yourtenant.sharepoint.com/sites/yoursite -UseWebLogin # Get favorite documents $favorites = Get-PnPListItem -List "Documents" | Where-Object { $_.FieldValues.PinnedDocuments -eq $true } # Display favorite documents $favorites | ForEach-Object { Write-Host "Name: $($_.FieldValues.Title), URL: $($_.FieldValues.FileRef)" } Replace yourtenant with your tenant name and the site name as well. In this example script, I am considering the Documents library, you can check from the multiple document library by converting this code to a for look for all the document libraries in the site