Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Read in the most recent file from SharePoint

MKanchwa
7 - Meteor

Hi

 

Can anyone help me with a workflow that reads in the most recent file from SharePoint location.

 

Regards,

Mustafa Kanchwala

1 REPLY 1
rkapoor
Alteryx
Alteryx

@MKanchwa there are a couple ways that you can do this. If you synch up your Sharepoint with OneDrive on your machine, then you can read the data/files from that location via the Directory tool and Dynamic Input. Have a look at the links below:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Directory-gt-Dynamic-Input/td-p/471103

With the Directory tool, you can sort the list of files for the latest one, and then use the Dynamic Input to read this data in.

Alternatively, you can leverage the SharePoint List Input tool:

https://help.alteryx.com/20212/designer/sharepoint-list-input-tool

Another option, is to sign up on the Beta for our new upcoming Sharepoint Connector (should be available soon). If you'd like to do this, let me know and we can organise this for you.

Labels
Top Solution Authors