I am trying to connect to an Excel file created in my OneDrive and when I try to create the connection I can see the file but the table drop down never populates. I have tied to just type the tab name into the table field and it errors.
Any suggestions?
Hi @MarcRohde,
There should be table pre-defined within the Excel worksheet, so that the Excel Action could get the corresponding table information from the Excel:
Create or delete an Excel table
If the Excel file contains Table, then please take a try to refresh the the Flow configuration page, then add the Excel action again to check.
Regards,
Michael