Answered

Insert Screen Values into specific Cells into a specific Excel File

(0) Share

Report

Posted on by AdamGill1965

311

I've also posted a similar question in the PowerAutomate community forum - but I feel that there must a simpler way than using Excel Online Scripts and Calls from a Flow to achieve this:

I have details of a "Job" on a Screen. On the Screen, I have a button to run a Flow to create a new Excel file from a Template in SharePoint, give it a unique name using "JobID" and a timestamp, then save it to a new location in SharePoint. All of that works fine.

Within the Excel file, I need to insert the JobID - and 3 or 4 other values that I have on the Screen, into specific Excel cells in the newly-created file. The advice I have been given is to use Excel Scripts and call them from within a Flow but that process is not only convoluted and complex but I have not been able to extrapolate the elements needed in my environment.

Is there an "easier" way - either within PowerApps or PowerAutomate - to specify a particular Excel cell ("C5") of a specific Excel File in SharePoint and insert Values collected/available from my PowerApps Screen?

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

BCBuizer 22,636 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @AdamGill1965 ,

Short answer: No, I assume you have some sort of form in Excel which you would like to populate, but that can't be done with Power Apps.

Longer answer:

In PowerApps, Excel TABLES can be used as a data source which are stored in Excel Files. When making changes to your Excel data source, you can specify the row and column of the table to be updated, but this is not the same as what you seem to refer to.

Was this reply helpful? Yes No
Verified answer

AdamGill1965 311 on at

Like (0)

Report
Copy link

Link copied!

@BCBuizer - thank you for the insights!

My (valid) workaround was actually simpler than I first thought: Add a Worksheet to the Excel File Template, place a Table in that Worksheet, put references from the Table in the Worksheet where I need them to appear in another Worksheet (where my Form is), then use "Update a Row" to insert the Values I need to.

Was this reply helpful? Yes No