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.2K Product Ideas
- 1.2K Ideas Exchange
- 1.3K Connect
- 1.1K Connectors
- 273 Workbench
- Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 524 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 433 Beast Mode
- 22 Variables
- 510 Automate
- 114 Apps
- 388 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 331 Distribute
- 76 Domo Everywhere
- 255 Scheduled Reports
- 65 Manage
- 65 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 67 Community Announcements
- 4.8K Archive