Excel Sheet to Domo
Hi Everyone, Happy Friday Eve.
I have a shared Excel workbook with multiple sheets that are appended together via power query into a master list sheet.
I'd like to set up a Domo connector to pull from this master list sheet only.
Is this possible? What is the ideal connector for this, and where is the ideal place to store the Excel workbook? Currently the book is just saved on one drive but it can be moved to share point.
Best Answers
-
I would suggest using the OneDrive for Business Connector. It is fairly straightforward to setup and you can control which sheet in the file you pull from:
If I solved your problem, please select "yes" above
1 -
@jmmc if you can't use the one drive connector (like me) you can also use a combo of Power Automate and the Email Connector. I set up Power Automate to read the file and send an attachment via email and then used the Domo Email Connector to bring it in.
**If this answer solved your problem be sure to like it and accept it as a solution!
0
Answers
-
I would suggest using the OneDrive for Business Connector. It is fairly straightforward to setup and you can control which sheet in the file you pull from:
If I solved your problem, please select "yes" above
1 -
Thank you @ColemenWilson
0 -
@jmmc if you can't use the one drive connector (like me) you can also use a combo of Power Automate and the Email Connector. I set up Power Automate to read the file and send an attachment via email and then used the Domo Email Connector to bring it in.
**If this answer solved your problem be sure to like it and accept it as a solution!
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 695 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive