Access to SharePoint excel file via Analytical app

[Rosh_2788]

Hello, 

I've created an analytical app and want to give Users the option to select the input file. These are excel file stored in SharePoint. How can use the File Browse tool to help user select excel files on SharePoint site?

Regards,

Rosh

[Joe_Lipski]

Hi @Rosh_2788,

I've just tested this myself and it works well if the end user has their sharepoint file directory synced to their local machine as they would effectively upload the file to the app/gallery.

Is this what you are after?

Thanks,

Joe

[Rosh_2788]

Hi Joe, 

Thanks for looking into this. Yes, this is what I'm after. I've created a similar workflow as you show above, however, when try to browse the file, it doesn't give me an option to connect to SharePoint? Below is what i see 

File..

Microsoft SQL Server..

Oracle..

Hadoop..

Other Database..

[Joe_Lipski]

Sounds like a great start @Rosh_2788

You won't see Sharepoint as a file type or database type as Sharepoint is just a repository for your flat files. What you and your users will need to do is SYNC sharepoint to your computer/file explorer.

Instructions on how to do that are here: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Connect-to-Sharepoint-with-A...

The second option is to map the network drive which is explain in the solution here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Connect-Alteryx-Designer-to-Excel-in-S... 

[Rosh_2788]

Thanks again Joe! 

Yaa, the first option is what I'm looking to set up, where the user gets to the location and can select the file. However, i dont see the sync option in SP 😞

The second is similar to how I pull files into alteryx from SP, but dont think its a user friendly option for users. 

[Joe_Lipski]

What do you see in SharePoint online, could you share a screenshot?

Here's what you should be able to do:

1. If you already have sharepoint synced to your machine, in file explorer, right click or a folder or file and click view online:
   1. 
2. Go back to the level you would like to sync and then click the sync button.
   1. 
      

[Joe_Lipski]

Hey @Rosh_2788

I've also just noticed that the Sharepoint File Input Tool has recently been released, which you might want to check out: https://help.alteryx.com/20213/designer/sharepoint-files-input-tool

Cheers,

Joe

[Rvelan12]

Hi Joe Lipski,

I have a similar Workflow like the above with SharePoint input Tool.

I connected the SharePoint input tool with File Browse through Action Tool. 

When I choose the a new file from File browse tool, which does not replace the configured file at the SharePoint input tool.

I attached my WF and the Action tool config screen shot.

Could you please check and let me know what I miss in my configuration.

I synched my SharePoint to my local machine successfully. Even after, new file does not replace the old file. 

For each run, it reads the old file only.

Regards,

RVelan.