You’re offline. This is a read only version of the page.
Hi All,
I'm a beginner to Power Apps and I'm having trouble writing to an Excel file stored on OneDrive.
I've created an application which allows users to update either all column values (button with ForAll / Patch commands and input box for values) or individual values (via an Edit Form) depending on which column it is.
When using both of these methods, the result often do not write to the Excel file first time, but will write the first changes only after the next change has been made anywhere else within the application. When attempting to change all row values for a given column for example, often only a proportion will write successfully first time, followed by the remaining values only after a second change is made elsewhere.
The Excel file contains two tables with one each on two different sheets. Both sheets contain 32 rows of data in total, with the Excel formatted table required for Power Apps starting at row 3 (as per the screenshot below).
Has anyone had this experience before or have a solution to where I'm going wrong?
Thanks,
Liam
Share
Report
All responses (
Answers (
477
