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 to any 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 to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive