cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Moving Files in Library After Upload from PowerApps

Hello,

Our scenario is seemingly simple but I'm not sure how to accomplish it.  

 

We have build a PowerApp that allows various users to upload Billing information for ~50 clients.  The PowerApp successfully uploads the documents to the library but just dumps them into it with no structure.  Its just a flat library.  Is there a way to automate moving those files into a folder structure?

 

This is what we have:

- PowerApps uploads the documents.  The users, during this process, are also selecting fields based on Dropdown (choice) values (columns) in the library.  The Columns are "Client Name," "Billing Period," and "Service."

- We have a folder structure in the library.

     - Client Name

          - Billing Period

Ideally, once the files are uploaded we would want to identify where the file should be moved and have that process automated.

 

Anyone have pointers how to do this?

1 ACCEPTED SOLUTION

Accepted Solutions

We figured it out.  I just had to add the variables to the path.  It will put the files in the proper location and, it needed, create the folder first if it is not already there.

View solution in original post

7 REPLIES 7
Super User III
Super User III

Hi!
"The PowerApp successfully uploads the documents to the library"
Is your PowerApp currently invoking a Power Automate Flow to upload the files?
If so, can you share a screenshot of the Flow design?
Thanx!


Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



 
 

Here is a copy of the flow:

Flow.JPG

Hu!
Please double click on each Flow action block to expand all of them so we can see their input details
Thanx!


Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



 

Hu!
Your flow seems to be designed to update file properties and add metadata (program, district, billing cycle) based on info received from your PowerApps.
So, you just need to make the destination folder dependant on some of this metadata, right?
I think you can do it by updating your current flow design, or by developing a second flow. According to your requirements, do you have any preference?
Thanx!


Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



We figured it out.  I just had to add the variables to the path.  It will put the files in the proper location and, it needed, create the folder first if it is not already there.

View solution in original post

 

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (4,180)