Update one sheet using Power Automate on several Excel files?

jmhoward ✭✭✭✭✭
edited 04/03/23 in Smartsheet Basics

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?