How to Show All the Files in a Group’s OneDrive Folder

With the Microsoft Graph API connection, you can easily link to a specific OneDrive folder from your group and display all the files inside. This makes it super convenient for your users to access the documents they need. You can set this up using the "Children in a Group's Drive Item (Folder)" use case. Just follow the step-by-step tutorial below to get everything working smoothly.

TABLE OF CONTENTS

• Prerequisites
• Step-by-step Tutorial
  • Step 1: Edit the ShortPoint Web Part
  • Step 2: Switch to Grid Mode
  • Step 3: Edit the Design Element
  • Step 4: Connect to Microsoft Graph API
  • Step 5: Use the Children in a Group’s Drive Item (Folder) Use Case
  • Step 6: Get the Drive ID
  • Step 7: Get the Drive Item ID
  • Step 8: Run Query and Connect
  • Step 9: Map Items
  • Step 10: Save

Prerequisites

• You must have ShortPoint SPFx version 8.6.0.0 and up installed on your SharePoint environment.
• You must be a ShortPoint Designer with an active license.
• You must have the Microsoft Graph API connection enabled. Go to How to Enable Microsoft Graph Integration for MS Graph API Connections to learn how.
• You must authorize the necessary permissions (Files.Read.All and Sites.Read.All) in the API access page. To check, go to your SharePoint Admin Center > Advanced > API access.
• You must have the Design Element you want to use to connect on your SharePoint page. For best results, we recommend using Design Elements that allow listing of multiple items (e.g., Icon List, Image List, Simple List, etc.).
• You must already have a OneDrive Folder with files:

• You must have the Group ID of the Group where your files are located. To get it, check out How to Find Your SharePoint Group ID.

Step-by-step Tutorial

Follow the steps below to get started:

Step 1: Edit the ShortPoint Web Part

Go to the SharePoint page you want to use and click Edit:

Close the Toolbox:

Select the ShortPoint web part and click the Edit Properties icon:

Step 2: Switch to Grid Mode

NOTEShortPoint Connect is currently only available in Grid Mode.

Click the Switch to Grid Mode icon:

Step 3: Edit the Design Element

NOTEYou can use any Design Element you want. For best results, we recommend using Design Elements that allow listing of multiple items (e.g. Icon List, Image List, Simple List, etc.). For this guide, we’ll use File List.

Click the cogwheel icon of the Design Element you’ll use:

Step 4: Connect to Microsoft Graph API

Go to the Connect tab:

Select Microsoft Graph API:

NOTEYou need to enable the Microsoft Graph API connection before using it. Learn more about it in How to Enable Microsoft Graph Integration for MS Graph API Connections.

Step 5: Use the Children in a Group’s Drive Item (Folder) Use Case

Search for Children in a Group’s Drive Item (Folder) and select it:

Step 6: Get the Drive ID

You will be prompted to fill in the details under Query Parameters.  Let’s get the Drive ID first. Click Get Parameter:

You will be prompted to add the Group ID of the group whose files you want to be shown. To get the Group ID, go to How to Get the SharePoint Group ID.

NOTEMake sure to take note of the Group ID. You will still need it for Step 7.

Click Run Query:

Under Response review, look for the Drive you want to use and copy its ID:

Click Go Back:

Paste the copied ID in the Drive ID field:

Step 7: Get the Drive Item ID

Click Get Parameter:

You will be prompted to add the Group ID again. Just use the Group ID you took note of in Step 6:

Click Run Query:

Under Response review, look for the folder you want to use and copy its ID:

Click Go back:

Paste the copied ID in the Drive Item ID field:

Step 8: Run Query and Connect

After adding the details needed under Query Parameters, click Run Query:

Click Connect:

Step 9: Map Items

Go to the Items tab:

Delete default content:

Use the link icon to map the properties you want to be displayed:

You can map any property you want. In our case, we used the following properties:

1. #name in the Title field - shows the names of the files as the titles.
2. #createdDateTime in the Subtitle field - shows the date and time the files were created.
3. #webURL in the Link field - redirects to the actual files when clicked.

(Optional) If you are using a File List, write the file type of your documents:

NOTECheck out ShortPoint Connect: Basic Tutorial to learn more about mapping properties.

Step 10: Save

Click Preview to see how the Design Element will look:

Click Update to apply your changes:

Select the eye icon to see your page in real time:

Once satisfied, click Save:

Amazing! You can now display files from your group’s OneDrive Folder, making it easier for your users to get the documents they need.

TIPGot tons of files? The Search & Filter Toolbar is a game-changer for helping your users find what they need! They can quickly search, sort, and filter through everything to locate the exact information they're after. Ready to set it up? Head over to Getting Started: The Basics of the Search & Filter Toolbar.

 

Related articles:

• How to Enable Microsoft Graph Integration for MS Graph API Connections
• Connection Type: Microsoft Graph API