Power Automate- Add row and cell value from Excel into Smartsheet
I have a Power Automate flow that's triggered when a response is submitted to MS Form. A row is added to an Excel sheet that contains several formulas and values are calculated for the responses. This has been working great, but now I'm being asked to utilize Smartsheet. Rather than recreating the entire Excel workbook with formulas in Smartsheet I would like to see if I can just add a step to the flow that inserts a row in the Smartsheet when a new row is added to the Excel sheet. BUT I want the value from Excel, not the formula, to transfer. As it's set up now, everything is transferring but all cells with formulas are showing as blanks in Smartsheet. Is there a way to set this up successfully?
Here's the basic flow:
Answers
-
I think this may be more of a Power Automate question than a Smartsheet one, but I think you need to use some sort of "get values" connector to capture the values in the cells vs. the formula.
-
@RAdamowicz good call, thanks! Posting over in the Power Automate forum as well :)
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives