Hello everyone,
I need help in segraggating files of a similar template from sharepoint. I'm currently dowmloading the details of the files from sharepoint and then using dynamic input to read the data of all the files. My concern is some of the files are of a different format which is not being read by the dynamic input. I want to add a filter which can only pass the files which are in the prescribed format to run the workflow successfully while get the list of files which are not in the prescribed format and shareing it with business. Need your help in solving this problem.
You are reading the file via Download tool? Can you share a bit more about your use case - this is quite interesting. So you skip the SharePoint input tool entirely?
Re: Your question on different schemas - the batch macro does a better job than dynamic input in this case... https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309
But one thing is, your Download - is it downloading a set of data as is or sheet names etc? What is the config like? I am fascinated by this new approach to SharePoint - I want to try it on my own also.