I’m currently facing an issue while setting up an Action Flow / Machine Learning Workbench solution to download and merge multiple Excel/CSV files from a SharePoint site.
I can see that it’s possible to download a single file using the Microsoft SharePoint Online module in Action Flow. However, my problem is that the folder contains multiple files with different names, and I would like to handle all of them within one solution.
Has anyone worked on something similar and could share some advice on how to approach this?
Best answer by Amishee Choksi
Hi Kamil,
You could try this approach out, which uses a combination of the action flows and MLWB: Recommended setup
In Action Flow: - Start withWatch Folders / Files on the SharePoint folder. This is the standard trigger for created/updated files - Use either: - one flow run per file, or - collect multiple file references and send them together to ML Workbench
In MLWB - Use Action Flow to get/list file references from the folder - Pass all file IDs / download URLs to ML Workbench, for example as a comma-separated string - In ML Workbench, split the string and iterate over the files - Merge all dataframes into one output
You could try this approach out, which uses a combination of the action flows and MLWB: Recommended setup
In Action Flow: - Start withWatch Folders / Files on the SharePoint folder. This is the standard trigger for created/updated files - Use either: - one flow run per file, or - collect multiple file references and send them together to ML Workbench
In MLWB - Use Action Flow to get/list file references from the folder - Pass all file IDs / download URLs to ML Workbench, for example as a comma-separated string - In ML Workbench, split the string and iterate over the files - Merge all dataframes into one output
