Connect/Pull SharePoint data file using the file path from a previous step

[Marcelo_Souza]

Hi Community,

I am struggling to find a way to get the data from a file on SharePoint using the path:

1) I got the list of file paths and created a logic that finds the path file for the day (that changes every day).

2) I am trying to input the path in the second SharePoint connector to be able to pull/read the data but with no success... the intention is to create a standalone solution to be handled by the Alteryx server.

Does anyone face the same issue or have any tips? I will really appreciate your feedback.

 

Thanks,

Marcelo

[FrederikE · Accepted solution]

Hey @Marcelo_Souza,

Your first input doesn't talk to the second Input with your current settup. 

If you use a batch macro instead, you can supply the Values from the select tool (pic) and input this into a batch macro. There you can use the Input to update the SharePoint tool with the paths.