How to fix Validation when Unable to see the Directories in the SharePoint Folder Data Sources Within SmartConnect

You’re creating folder data sources for the SharePoint platform using the provided Graph connection, and you are unable to browse sites or directories, resulting in the following error:

Error: Could not GetDirectories for OneDrive. Please check permissions when connecting to SharePoint.

Error: No directories found

Cause

The underlying issue is that the authenticated account either lacks the necessary API permissions or is missing permissions on the SharePoint site.

Solution

1. Verify that the API permissions for your Graph connection are configured according to the documentation below
   Setting up a Microsoft Graph Odata Connection
2. Authenticated User used for the Graph connection: Ensure the account has a valid Microsoft Office license and access to Microsoft Teams and sharepoint access. Try logging in to verify that access is working correctly with MS Teams as well as sharepoint.
   FYI: If you encounter the error “Failed to get license information for the user. Ensure the user has a valid Office 365 license assigned,” please confirm that the user has an appropriate Office 365 license assigned.
3. Make sure the SharePoint site is added to Microsoft Teams as a group or channel
   For Example: Contact your SharePoint Admin, then navigate to Site Settings → Go to Site → General → Add site to Teams (set to Yes). After that, the site became visible in both Graph Explorer and SmartConnect.
   The issue is likely due to the SharePoint site not being associated with a Microsoft Teams group. To resolve this, ensure that there is at least one Teams group and that it’s properly linked to the SharePoint site.
   Reference: Manage sites in the SharePoint admin center
4. Ensure that at least one file or one folder/directory exists within the SharePoint site/page so it can be browsed in SmartConnect
5. Optional -This point is not related to SmartConnect. If the below warning message on your SharePoint site is currently blocking access for some reason i.e., “You are seeing a limited version of this page because Office Graph is turned off” – Go to the SharePoint Admin Center >> Navigate to More Features > User Profiles > Manage User Profiles >> Search for the user’s name and edit their profile >> At the bottom of the page, check the box to enable OfficeGraphEnabled.

MS Graph API Testing:

Go to the Graph Explorer https://developer.microsoft.com/en-us/graph/graph-explorer and sign in as the authenticated user.

For Example, see my SharePoint site ‘eOne Solutions’. I want to retrieve details about folders that have subfolders, such as the ‘failed’ folder.

Note – I highlighted the IDs using color coding in the sequential API calls.

1. Endpoint https://graph.microsoft.com/v1.0/me/joinedTeams   — This is the main endpoint that we are using for SmartConnect i.e., joinedTeams

2. Get the ID (i.e., group ID) from the response for the given group and set the ID for the URL below, then run it inside Graph Explorer again. 
   https://graph.microsoft.com/v1.0/groups/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/drive/items/root/children/

3. Get the ID (i.e., folder ID) from the response for the given group and set the ID for the URL below, then run it inside Graph Explorer again. 
    
   https://graph.microsoft.com/v1.0/groups/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/items/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/children

Have a question? Please reach out to us at support@eonesolutions.com