Connecting to Microsoft Hosted Workbooks

Connections can be created to .xlsx files stored in OneDrive for Business, Teams and Sharepoint Online in Office 365. This includes files uploaded to Teams Chats and any file where the user has read access. It does not include attachments to outlook emails, calendar events, to-dos or OneNote Notebooks. 

Get started by clicking Data in the left hand panel. 

The Data Connections menu will appear.. Click Create a Connection button to create a new connection. 

You will see a new window with different data connection options. Choose the Microsoft Excel Workbook.

If you haven’t already connected to your Microsoft account. Connect will request you grant access. If you have already connected to your account you do not need to grant access again, click the name of your account to proceed.

Log in with your Microsoft Account. 

Click Accept to authorize Connect with your Microsoft Account. 

Now that your account is connected you can enter in a search term to search through your excel files in OneDrive for Business, Teams and Sharepoint Online. Then click the search button. 

Results will appear below the search bar. Click the corresponding select button to choose a file. 

Select the sheet from the workbook you want to use then click Continue. 

Adjust the data Columns for name, data type and use the preview to validate your data connection is correct then click the continue button. 

Set your synchronization frequency

Then name your connection then click Continue

Once the Connection has been made click Close. 

‍

Now your app is connected to a Microsoft Workbook. You can drag and drop values or records to build out your Connect App. Follow this link to learn more about building an app from scratch

‍

‍