From a Sharepoint teamspace read always the latest excel File

Hi,

I have seen that threads like this were already answered a couple of times but the answers provided were unfortunately for me not clear enough.

I know ho to read a list from Sharepoint but in this case I'd like to connect to Sharepoint and from a teamspace read just the latest file added. (the identification of the latest file could be either through "date added" or part of file name (eg. List_2022_04)

Can anyone help with this?

Thanks

Sharepoint

Accepted answers

gabrielvilella

@Davide11 I have done this before. I recommend you using the new SharePoint connector to first get the list of file names for a folder, then read them using a batch macro with the SharePoint connector within it. You will need to update, using the Action tool, the file path, file name and sheet name (if the sheet name is not always the same).

All comments

IraWatt

Hey @Davide11,

How are you reading in the SharePoint files, are you using the SharePoint file input tool? If you can guarantee the file format and when the new file will be made available you could use a macro to dynamically change the file path to the new location.

Do you have a link to the answers you thought were similar?

Thanks,

Ira

Davide11

Hi @IraWatt

I actually haven't started yet implementing it because I am new to Alteryx and so far I just read files through the SharePoint file input tool.

Unfortunately I cannot guarantee that the format is kept and ther is no date when new files will be made available, it could happen any day any time.

Solved: Read in the most recent file from SharePoint - Alteryx Community

Thanks

gabrielvilella

IraWatt

Ah no worries @Davide11, from the looks of it the one way of doing this is to sync the folder up to your one drive Sync SharePoint files and folders (microsoft.com) then using a workflow like this:

Essentially the directory tool shows all files in a given folder and their information. We can then sort them by created time descending. Then select the top (most recent file) with the sample tool. Finally you then pass the file location to a dynamic input. This would ensure the most recent file is always inputted.

Newest file.yxmd

IraWatt

@gabrielvilella didn't know you can do that with the tool!

that's a much better approach as it would save space on OneDrive I assume.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703