Forum Discussion

JustinR's avatar
JustinR
Copper Contributor
Sep 02, 2019
Solved

Move files based on user department

Hi All,   I really need some help. I am trying to design a solution where our team create a document from a template in a read only library, the flow basically creates a new document and copies the...
Microsoft Flow
PowerApps
sharepoint
  • Damien_Rosario's avatar
    Damien_Rosario
    Sep 02, 2019

    Hi JustinR 

     

    Based on your scenario (assuming I understand it right), I would save the new document to the users Department library FIRST and then add in the file attributes, etc once it's been created there.

     

    It sounds to me that the drop-off library is purely a transactional place that you don't really need if you just generate the file in the desired location up front.

     

    Before you create the new file, use Get user profile (V2) to get the users account attributes (use their email as UPN) and then the Department attribute could be used as part of the location path. 

     

    Hope that makes sense?

     

    If I've misunderstood anything, please let me know and I can revise the suggestion above.

     

    Cheers and best wishes

    Damien

Damien_Rosario's avatar
Damien_Rosario
Silver Contributor
Sep 02, 2019

Hi JustinR 

 

Based on your scenario (assuming I understand it right), I would save the new document to the users Department library FIRST and then add in the file attributes, etc once it's been created there.

 

It sounds to me that the drop-off library is purely a transactional place that you don't really need if you just generate the file in the desired location up front.

 

Before you create the new file, use Get user profile (V2) to get the users account attributes (use their email as UPN) and then the Department attribute could be used as part of the location path. 

 

Hope that makes sense?

 

If I've misunderstood anything, please let me know and I can revise the suggestion above.

 

Cheers and best wishes

Damien

Resources