Hi all - Thank you, in advance, for your wisdom and guidance - and, apologies if this has been asked - I've searched, but just can't seem to find the solution that matches this question...
Your assistance and/or guidance is desperately requested!
What I'd like to be able to do is create an automation whereas whenever an excel file is dropped into a specific OneDrive (sharepoint) folder, it searches for a specific worksheet and then extracts the data needed from that worksheet. Here are the things that are tripping it up, though:
- The file names will be different. There can always be the same root, but the end of the file name will always change. Let's say for example, files will be dropped in named as such:
- DataDump2022_Person1_Wk2
- DataDump2022_Person1_Wk3
- DataDump2022_Person2_Wk2
- And so on....
- Each one of those files, though, is organized the same. Same worksheets. We need it to find the worksheet "ExportData" and bring that data in a new row on a master Excel worksheet.
- The Columns on "ExportData" are always going to be the same and they will map to the same column structure on "MasterImportData" - which, for arguments purposes, will be the repository of information doc where we are adding a new row each time a new file shows up.
It seems very doable, but I'm stuck on the "it's a different file name" thus, I don't know how to tell PA to look for the organized data in a file that I can't define, but is definable once you're in it!
I look forward to your solution or direction, and equally look forward to the time when I can assist on the flip side!
Bneat
