SharePoint Files Input

[bsanthoshpk]

Hi All,

I hope you are all doing well. i am using SharePoint Files input tool, currently I am facing one issue. Normal input tool able to get full path.

Example:

But while using SharePoint Files Input not able to get full file path. if there any way to generate full path ?

Thanks.

[BS_THE_ANALYST]

@bsanthoshpk you could get the full paths using this option. If you want this appended to the actual data, then you could use two sharepoint input tools, and append the appropriate path?

[bsanthoshpk]

Hi @BS_THE_ANALYST 

Thanks for the reply. in my configuration window not showing "Read only List of full path. can you tell which version currently you are using? Thanks.

[BS_THE_ANALYST]

@bsanthoshpk great spot! I'm using the most up to date version of this tool:

Mine says 'Sharepoint Input', yours says 'Sharepoint Files Input'. I believe Sharepoint Files Input has been revamped into Sharepoint Input.

Hopefully that helpful.

[BS_THE_ANALYST]

@bsanthoshpk just out of interest:

if you select that option, will it bring all the files paths through? I know the data doesn't come through, but does the file paths come through into the workflow?

If yes, you can implement my previous suggestion.

[bsanthoshpk]

@BS_THE_ANALYST  thanks a lot. i have one more Query any possibility output full path written in output file after processing batch macro output?  using SharePoint input tool?

[bsanthoshpk]

@BS_THE_ANALYST  yes it's bring file path. but the problem is while processing data it's not providing the full path in output file.only providing file name and sheet name not for full path. 

[BS_THE_ANALYST]

Okay here is my suggestion @bsanthoshpk :
Use one Sharepoint Input tool to read in all the Full Path information. This should also provide you with a field that has the File Name in aswell. We will use this in our Join tool:

Now on your other Sharepoint Input tool, bring the file in that you want (make sure you tick the LinkFilename in metadata)

Last thing, join the two together. This will bring the filepath onto each record now:

Hopefully this works.

[bsanthoshpk]

Hi @BS_THE_ANALYST 

Once again thank you for your reply. I expecting exactly the output files contains which record coming from which full path?

Example: 

Sp tool producing only record against file name.

batch macro after data processing. I am expecting below output. Thanks.

[bsanthoshpk]

Hi @BS_THE_ANALYST , 

Hope you are doing good,. 

FYI.. 

We checked with alteryx support team. Above mentioned option not available in SharePoint files input tool and also there is no workaround for this one.Thanks.