
Announcements
I success read excel file from Sharepoint use Excel online(Business) connectors.
But I want to read the excel, and get the excel table, how to do?
I can get the excel worksheets as table.
Hi @Andrewlu81 ,
Do you mean you want to retrieve Excel table data into Power Automate for further operation?
You can try this action:
But before that you need to create a table in Excel as Power Automate can only read data from Excel via table.
Here's official document of Excel for your reference:
Excel Online (Business) - Connectors | Microsoft Learn
Community Support Team _ Wenjuan Zou
If this post helps, then please consider Accept it as the solution to help the other members find it.