Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Replicating Dynamic Input with SharePoint Files Input

MattBenj
9 - Comet

My company is transitioning from shared network folders to SharePoint and OneDrive so I'm working on updating workflows with the SharePoint Files Input tool (version 2.0.1 using Client ID/Secret/Tenant ID) . One scenario I've been having trouble replicating is the combination of a Directory tool and Dynamic Input tool like the workflow below.

 

MichMatt_0-1651678814826.png

The specific example I'm trying to solve is the need to get the names of all the files in a SharePoint folder, filter them based on name/meta data, then open the select files. I've figured out how to replicate the Directory Tool portion (using the "Import only list of file path" option) but I haven't found a way to replicate the Dynamic Input tool. Has anyone figured out how to do a Dynamic Input style input with the SharePoint File Input Tool? 

 

Some things I've tried.

-  Opening all files in a folder with SharePoint Input Files then filtering based on the metadata but if there are 100 files and you only need 1 that would involve opening too many unneeded files. 

- The Input Data Tool has a wildcard search feature but I can't replicate that in SharePoint either.

- OneDrive files via the Input Data Tool works in Designer but doesn't work once I upload to the gallery

21 REPLIES 21
MattBenj
9 - Comet

@bertal34 My original post, with the directory tool, was the normal input tool functionality I was trying to replicate with SharePoint. If you go to the Accepted Solution you'll see I was able to do this with a SharePoint tool wrapped in a batch macro.

bertal34
9 - Comet

@MattBenj 

Right, I understand the solution using the batch macro.  I just missed the part about targeting the latest file using Max Date (before going into the macro).  Now I see in the SP Input tool under Configure File you can Attach Metadata and select date fields “Created” or “Modified”.

Labels