Read Rows in Excel Using Power Automate with ‘Create Table’ Action When working with Excel files that need to be imported into a SharePoint list, you may encounter scenarios where the data is not already in table format. This can be challenging, especially if the Excel files are automatically generated by an external system and cannot be manually updated. This blog post demonstrates how to dynamically convert raw data into a table using the Create Table action in Power Automate and subsequently read rows using the List rows present in a table action.