Hello,
I am running circles, the process seems to be easy, but got complicated for some reason. I have a daily e-mail with the sales report saved on the specific folder on SharePoint. This folder contains only these excel reports with the naming YYYYMMDD_Reports.xlsm. These reports are standardized, the same data structure, the same names of sheets, etc.
What I would like to do is create a flow that will consolidate all of these files (only one sheet from each file) and save in the access database.
Challenge 1:
For some reason, I got a warning that the date format is inconsistent for some of the reports and that these files will be skipped. I have checked the reports and they do have the same layout...
Challenge 2:
My workflow is using the input tool with *.xlsm (getting all the *xlsm files in the folder). However, when I wanted to schedule this, I got a warning that file *xlsm has not been found. Which - from the technical point of view - is true, because there is no such file as *xlsm, this was just reference in the input tool to get all the files from the folder.
Solution?
I believe that it needs to be processed with a directory tool or some macro? Does anyone know how to do it? This should solve both challenges.
Attached is my workflow. Note that in that case, it seems to be correct (challenge 1 is not applicable), because I have created dummy data. I cannot share the original files due to the sensitivity...
