How can we help you today?

How to Display Rows in an Excel Table

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:


sample excel with table


And here’s how it looks when we connect the table to a Design Element using Microsoft Graph API:


sample list connected to table


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:


Edit


Close the Toolbox:


close icon


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


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:


Switch to Grid Mode


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:


Cogwheel icon


Step 4: Connect to Microsoft Graph API

Go to the Connect tab:


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.


Microsoft Graph API


Step 5: Use the Rows in Workbook Table Use Case

Search for Rows in Workbook Table and select it:


Rows in Workbook table


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:


Get Parameter


Find the file you want to use and copy its ID:


copy ID


Click Go Back:


Go Back


Paste the copied ID in the File ID field:


paste ID


Step 7: Get Table ID

Now, let’s get the Table ID. Click Get Parameter:


Get Parameter


Since we already have the File ID form step 6, [1] paste it in the field provided and click [2] Run Query:


paste ID and run query


Look for the Table you want to use and copy its ID:


copy Table ID


Click Go Back:


Go back


Paste the copied ID in the Table ID field:


paste ID


Step 8: Run Query and Connect

Click Run Query:


Run Query


Then, select Connect:


Connect


Step 9: Map Items

Go to the Items tab:


Items tab


Delete default content:


delete default content


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


link icon


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

  1. #values_0_0 in the Title field - shows all the items in the first column of the table.
  2. #values_0_1 in the Subtitle field - shows all the items in the second column of the table.
  3. #values_0_3 in the Description field - shows all the items in the fourth column of the table.


map items


(Optional) If you’re using an Icon List, choose the icon you want to use:


icon


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:


Preview


Click Update to apply your changes:


Update


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


eye icon


Once satisfied, click Save:


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. 

Search & Filter Toolbar



Related articles:

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

World's best intranet sites are designed using ShortPoint

Get started today! Learn more
See all 27 topics

Start a trial

Ignite your vision. Install ShortPoint directly on your site, or play in sandbox mode. No credit card required.

Get started today

World’s best intranet sites are designed using ShortPoint

Thousands of companies using ShortPoint everyday to design, brand and build award winning intranet sites.

Get started Learn more