Power Automate can write values to specific cells or ranges in Excel without the need for a premium license. By using the Office 365 Users - Send An HTTP action, you can access an Excel file stored in OneDrive and write values to it. This article provides a step-by-step guide on how to write values to a specific cell or range in Excel using Power Automate. It covers topics such as creating an Excel spreadsheet in OneDrive, finding the DriveId of the workbook, writing a value to a cell, and writing values to a range of cells. The article also includes screenshots and examples to help you understand the process.
Login now to access my digest by 365.Training