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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 620 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 742 Beast Mode
- 58 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive