After adding and authenticating a OneDrive for Business or MS Graph Connection, you can pull data from an Excel or CSV file in your OneDrive for Business account on a timed refresh using Data Source Connectors, which is the focus of this article.

Adding

Data Source Settings

• Navigate the side menu to Data Hub > Data Sources
• Hover over a data source and click the “Settings” icon link ()
• In Settings, hit the “Add Connector” button
• Select the relevant option to add the connector

This will refresh the page with the newly added connector ready for configuration.

Nothing has been saved at this stage, so save your connector after making any changes to enable or update it.

Alternatively, if you’re viewing the rows of a data source, you can navigate to the Settings page using the option under the page’s title.

Configuring

After adding the Data Source Connector, you can configure and add the required properties.

Refresh Frequency

The time interval during which data is pulled and refreshed by this connector.

Using Connection

If you have more than one OneDrive for Business or MS Graph connection configured on your account, you will need to choose which configured account you’ll use for this form connector.

Site Name

This field is required if you use an MS Graph connection to authenticate this form connector; then you will need to provide a Site Name. This field value can be either the SharePoint site URL (e.g., tenant.sharepoint.com/sites/mysitename), or simply the Site or Subsite name.

File Location

Enter the file location on Microsoft OneDrive to import data from.

Location should be entered in the following format: ‘FolderName/Folder2/FileName.csv’.

The following file types can be imported as a Data Source: Comma-Separated Values (.csv), Microsoft Excel (.xlsx).