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.
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
Solved! Go to Solution.
@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.
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”.