@Stavros Mitchell The best method to accomplish this would be to stop the sync of finance, move it out of public, and then create 2 sync groups. The first sync group would be for all of public to go to Azure files and enable cloud tiering. The second sync group would be for finance to go to Azure files and then a second endpoint to the Azure ERP server.
This would allow you to sync all the subfolders in Public to Azure files with cloud tiering, while also maintaining the sync of finance to the Azure ERP server. It is not necessary to create 15 other sync groups, as this would not provide any additional benefits and would only increase complexity and management overhead. By creating 2 sync groups, you can easily manage and maintain the syncing of your files and folders.
Additionally, you can use the GhostingExclusionList registry setting to exclude specific files or folders from cloud tiering. This can be useful if you want to ensure that certain files or folders are always available locally on the server, without being tiered to Azure.
For more information on managing Azure File Sync tiered files, see the Azure File Sync documentation.
I hope this helps. Let me know if you have any other questions.
Please do not forget to "Accept the answer” wherever the information provided helps you, this can be beneficial to other community members.