I have this daily process that involves the following the steps:
Step 1: each day an Excel file arrives in my mailbox
Step 2: transfer Excel file to a Sharepoint site folder
Step 3: format Excel file as a table
Step 4: copy/append Excel data into a Sharepoint List.
Note: the above steps are repeated daily for each new Excel file that arrives in my inbox.
I have created a flow that executes steps 1-3 successfully.
I created another flow for Step 4 however, the flow throws an error "No table was found with the name ‘Table1’ " Please refer to screenshots attached for further details.
Appreciate any help on how to resolve the error.