I am investigating for a possibility for SharePoint Online to automatically and dynamically move files into specific folder.
We have a folder on a SharePoint library where files were exported into from another source. These files are labelled with account number and date of the report. On the other side of things, each of these accounts have a folder on SharePoint with the account number as a folder name within the same SharePoint site. Is it possible for SharePoint (SharePoint Online) to automatically move these files into corresponding folders?
I am thinking about SharePoint Workflows, but SharePoint Designer doesn't seem to have an "out of the box" solution, or perhaps I am missing something.
Can someone help? Many thanks.