We are trying to create form with workflow able to save attachments in SharePoint site for other processes usage. However, the workflow connector doesn't allow to make connection to specific SharePoint site. With only connection to entire SharePoint domain, this raised a concern by our security admin of which it is a risk. It is important as large organization having a lot of sites in SharePoint with specific task usage and cross site's function.
@Guest Unfortunately, with the default enterprise application, there is no way to scope permissions down to the site level. Access must be governed using the permissions of the user creating the connection.
We do have an upcoming feature that will allow you to create and use your own enterprise application, enabling the use of a service principal to manage permissions instead of relying on user‑delegated access.
Keep an eye on the “What’s New” page over the next month to check when this becomes available, and you can then evaluate whether it meets your requirements.