Hi
I am just starting to play with the Excel (Business) connector in Flow and already it's fighting me! The original plan was that a Excel file would be saved to a specific location, Flow grabs the file and uses it to populate a SharePoint list.
I've discovered that dynamic file names are not supported so I've created a couple of simple flows to workaround that issue. The first (which works) grabs the new file that lands in the specific folder, copy it to a new file name and move that new file to another folder called "Processed".
The processed file name is always the same "Parts.xlsx" and I though this would be sufficient for Flow to pick it up and then use the "Create Table" function to convert it into a table ready for upload into SharePoint.
However when the flow runs on the processed file I get the following message
The Excel Create Table connector configuration:
After the flow has failed I can edit it and click through the "File" dialogue to locate the "Parts.xlsx" file and then re-run the Flow based on the last failed result and it completes. So it looks like just creating a new file with the same name doesn't work, is that right? is there a way of getting around this at all?
Any thoughts/help gratefully received.
Rob
