Consume / read plain Excel (without table) from Power Automate

Blog post link: https://fernitudela.dev/2024/04/15/consume-read-plain-excel-without-table-from-power-automate/ You can't access, from Power Automate, to the information of different Excel files where no tables are created... or can you? In this post we are going to analyze the problem and see how we can troubleshoot the limitation for all our implementations using Excel scripts 00:00 Introduction 00:06 Requirement: Read plain excel from PA 01:50 Understanding the problem/limitation 03:08 my solution to create the Excel table prior to consume it 07:40 Extra: check if there's a table (make it idempotent) 11:10 Another extra test, just in case 11:45 Thank you!