Dynamic Input from Sharepoint

[Riox078]

Hello Folks, 

I have  a requirement of dynamically taking input from Sharepoint. Below is the details of the requirement. 

I have around 30+ Sharepoint file that need to loaded into Alteryx. The files are of xlsx type. These excel files contains sheets which need to loaded into Alteryx. These files are basically files of products which contain forecasted quantities. These are generated every month. 

My ask is, Is there anything in sharepoint tool where we can have this dynamically. I mean whenever the new file with the current Month Year (For Eg. Forecaste_072025) gets loaded into Sharepoint folder the files gets loaded into the flow and the flow runs at scheduled time.

All I want is to have a dynamic load of the files which will be added to the folder. Currectly the folder has around 30+ files. All the files have Month Year at the end of their name.  

[aatalai]

@Riox078 where is the control parameter? 

[Riox078]

I have removed it. But even while adding it it will give the above error. 

[Riox078]

I really need to find the solution. I have searched on the whole community but cannot find the solution to this problem 

[aatalai]

@Riox078 try this

Step 1 put a sharepoint input tool onto a canvas, set it up and select a file (this includes in the configure file section too)

Step 2 add a control parameter and  action tool and connect it to the sharepoint input tool

step 3 click onto the action tool and select the path option

Step 4 click on replace a specific string at the bottom of the actions config window

Step 6 keep only the string you want to update, which from my understanding will be the date

Step 7 put an output macro tool in and save 

Step 8 insert it into a new workflow and a list of dates (in the correct format going into the control paramater) and for the date field to be the what you select for the question

Let me know how you get on

[Riox078]

@aatalai  I have added only data part as you mentioned. And have attached the macro to SharePoint tool as a input in the main workflow. But I am receiving the below error which is there in there in 2nd screenshot attached. The file in the input is one of those file which will be there in the macro.

[aatalai]

@Riox078 thanks for this can you try with a text input tool with one date inputted manually and let me know how you get on with that please? As I don't think having a sharepoint input tool feeding the macro is correct.