Skip to main content
Nintex Community Menu Bar
Solved

NWC Document Generation - OneDrive for Business

K
Forum|alt.badge.img+8

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)

Best answer by butlerj

@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:



  1. Create a connection to OneDrive using a dedicated Service Account

  2. Within the workflow create new folder with the employee's name




  3. You can then DocGen the file to this location




  4. And finally you can share the new file with the employee





 


Let me know if that helps!

View original
Translate
    Did this topic help you find an answer to your question?

    4 replies

    butlerj
    Nintex Employee
    Forum|alt.badge.img+20
    • butlerjNintex Employee
    • Nintex Employee
    • 260 replies
    • March 11, 2020

    @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:


    Translate
    K
    Forum|alt.badge.img+8
    • kkittinger
    • Author
    • Rookie
    • 93 replies
    • March 11, 2020

    @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.


     


    Translate
    butlerj
    Nintex Employee
    Forum|alt.badge.img+20
    • butlerjNintex Employee
    • Nintex Employee
    • 260 replies
    • Answer
    • March 12, 2020

    @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:



    1. Create a connection to OneDrive using a dedicated Service Account

    2. Within the workflow create new folder with the employee's name




    3. You can then DocGen the file to this location




    4. And finally you can share the new file with the employee





     


    Let me know if that helps!

    Translate
    K
    Forum|alt.badge.img+8
    • kkittinger
    • Author
    • Rookie
    • 93 replies
    • March 17, 2020

    @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.


     



    1. Even though connector is set to a certain person, can you still make the output of the Document Generation go to either another users OneDrive or to a specific file location?

    2. We have noticed and I tested this with myself and one of our techs that has Domain Admin rights, that when I sign into the connector I see my OneDrive area but we out tech does it only shows the tenant admin area and not their OneDrive. Is there something different for people that are Domain Admins?


    Thanks again for all the information.


    Kevin

    Translate

    Reply


    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsCookie Settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie Settings