We have been trying to work with Document Generation insided Workflow Cloud. With this we are trying to grab templates from employees personal One Drive for Business areas and put files into employees personal One Drive for Business areas. With this we have attempted multiple ways (listed below) to do this with no results. Is there anyone in the community that are doing this that can give some insight.
1) Build a OneDrive for Business connector to our top level site collection <tenant>-my.sharepoint.com - Works to build connector but cant get to individual user personals when writing out paths to a template or output file when in Document Generation action.
2) Build a OneDrive for Business connector to employee personal <tenant>-my.sharepoint.com/personal/<user> - Get connector can't be built error when signing in as the Domain Admin or the user creds to access. (both are site collection admins)
Solved! Go to Solution.
@kkittinger When using the OneDrive for Business connection the browser-stored credentials are accessed to create connections, which should give you access to the personal folder of the "connection owner" (see screenshots below). Are you trying to access *other* users personal folders, or the personal folder of the user that was used to create the connection?
My OneDrive Folders:
NWC Connector under my credentials:
@butlerj thank you for replying to this. Hope my explination helps in this.
So we have tried to make connectors to the individuals OneDrive for Business and get an error message that the connector couldnt be built (screenshot below). We get this error wether the admin signs in or the employee does. Only time we are able to make a connection is when we go to our defualt area for OneDrive for Business (<tenant>-my.sharepoint.com) using Admin Login. All our employee OneDrives are built under this as site collections /personal/<users>. Our Admins have rights to all these as site collection admins. So in a way yes, we would be trying to access *other* users personal folders/OneDrive to either grab the template or put the file built.
To note our licences are for Office and SharePoint Online. So as new employees are onboared and after we migrated to the cloud it build employees MySites and tied there OneDrives to that. Not sure if this effects how the connector actually behaves.
@kkittinger I've done a little digging into this and I believe that this is a restriction with how the OneDrive Graph API functions, as I've done testing with both our actions and the Power Automate OneDrive integration and both work the same way.
When making a connection to OneDrive for Business you do need to connect to the tenant URL (<tenant>-my.sharepoint.com) and that will create a connection to OneDrive with the credentials of the user making the connection. This will give that connection access to that user's personal OneDrive folder, but does not give access to other user's personal folders (even if the connecting user is a tenant Admin). The only way to get direct access to another user's pesonal folder is to create another connection using that user's credentials, which can then be used as the "target" for delivering files.
Given that you cannot programatically create and access new connections while the workflow is running, I believe you will need to take a slightly different approach to your use case. I would suggest something similar to what I've outlined below:
Let me know if that helps!
@butlerj Thank you for the reply.
This is what i was figuring as the connector is set up like the Google one where individual users would have to log on to access those certain areas. This makes it very clear on this matter.
I have two additional question for you one of which I think I already know the anwser to based on what you have provided.
Thanks again for all the information.