Power Automate Excel Get The Value Of A Cell Or Range
Power Automate can retrieve cell values from Excel without being included in a table. It can also retrieve a range of cells outside of a table. By using the Office 365 Users - Send An HTTP action, Power Automate can access an Excel file stored in OneDrive and retrieve values from it. This action does not require a premium license. The article provides a step-by-step guide on how to retrieve a single cell value or a range of cells from an Excel workbook using Power Automate. It includes instructions on creating a new flow, extracting the DriveId of the workbook, and using the Send An HTTP Request action to retrieve the desired values.
Article 5m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time