Update one sheet using Power Automate on several Excel files?
Hi there,
I have a use case where I have a bot creating Excel files daily. I'd like to use Power Automate to tak the data from those Excel files and add it as rows into an existing sheet in Smartsheet so that I can add workflows to the data in those rows.
I tried setting up a flow in Power Automate, but was stuck on two areas. First, I could only point to a specific file, but the file changes daily.
Then, I wasn't sure how to map the Smartsheet rows. When I first tried the flow, it copied all the Excel data into a single cell in the Smartsheet sheet. My colleague and I tried various ways of mapping, but couldn't sort it out:
Has anyone successfully set up a flow like this?
Thanks!
Jackie
Answers
-
Hey @jmhoward
If you don't receive a response from Smartsheet members, you may want to try asking this in the Power Automate Community, as they may be better equipped to help setting up flows.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives