Connecting to Sharepoint for Spreadsheets

Hello!
For my current dataflow, one of my input datasets relies on an external file from my desktop:
I was wondering if there is a way to link it to a spreadsheet that is on Sharepoint.
I'm not too sure if I have to use this connector for that to happen:
Additional question:
If that excel file on Sharepoint is updated (with a new row of info for example), is there a way that it would automatically update the DF?
Best Answer
-
I use the Microsoft SharePoint Online Rest Connector to connect several Excel files to our Domo instance. You can use the scheduling section of the connector to have it pull data in from the spreadsheet as often as you would like. You will want to read through the KB article for this connector as it requires some initial work in the Azure Portal. Once that is done once, you can connect to any number of Excel files. Here's the KB link: https://domo-support.domo.com/s/article/360043436773?language=en_US
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Answers
-
I use the Microsoft SharePoint Online Rest Connector to connect several Excel files to our Domo instance. You can use the scheduling section of the connector to have it pull data in from the spreadsheet as often as you would like. You will want to read through the KB article for this connector as it requires some initial work in the Azure Portal. Once that is done once, you can connect to any number of Excel files. Here's the KB link: https://domo-support.domo.com/s/article/360043436773?language=en_US
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 303 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 105 SQL DataFlows
- 641 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 771 Beast Mode
- 73 App Studio
- 43 Variables
- 719 Automate
- 185 Apps
- 463 APIs & Domo Developer
- 57 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 402 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 9 Software Integrations
- 135 Manage
- 132 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive