Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
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