NOTEThis feature will be released in version 8.6.0.0 for SharePoint Online and is not currently available.
With the Microsoft Graph API connection, you can pull rows from a specific Excel table and showcase them in your SharePoint page. For example, here’s a table we made:
And here’s how it looks when we connect the table to a Design Element using Microsoft Graph API:
You can accomplish this by using the “Rows in a Workbook Table” use case. Follow the detailed guide below to help you set everything up.
TABLE OF CONTENTS
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) 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 have Excel files in your OneDrive with tables.
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 Icon 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 Rows in Workbook Table Use Case
Search for Rows in Workbook Table and select it:
Step 6: Get File ID
You will be prompted to fill in the details under Query Parameters. Let’s get the File ID first. To do that, click Get Parameter:
Find the file you want to use and copy its ID:
Click Go Back:
Paste the copied ID in the File ID field:
Step 7: Get Table ID
Now, let’s get the Table ID. Click Get Parameter:
Since we already have the File ID form step 6, [1] paste it in the field provided and click [2] Run Query:
Look for the Table you want to use and copy its ID:
Click Go Back:
Paste the copied ID in the Table ID field:
Step 8: Run Query and Connect
Click Run Query:
Then, select 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:
- #values_0_0 in the Title field - shows all the items in the first column of the table.
- #values_0_1 in the Subtitle field - shows all the items in the second column of the table.
- #values_0_3 in the Description field - shows all the items in the fourth column of the table.
(Optional) If you’re using an Icon List, choose the icon you want to use:
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 showcase the tables you’ve made in Excel.
TIPWant to find the item you need quickly? No problem! The Search & Filter Toolbar has your back! It can help your viewers find exactly what they need in a snap. They can search, sort, and filter through all those items with a click or a simple search. Ready to give it a try? Check out Getting Started: The Basics of the Search & Filter Toolbar.
Related articles: