Read in the most recent file from SharePoint

[MKanchwa]

Hi

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

Regards,

Mustafa Kanchwala

[RishiK · Accepted solution]

@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.