cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

When File is added to folder, Update Colomn from another list

Hello,

 

I need some help with the final step in my project approval workflow

 

I have a list for a project submission where a user adds a few details and an excel file that is then routed for approval. Once fully approved by all parties, the attachement that was included gets uploaded to a secondary folder for the project team to review. In that folder is a colomn for department that i want to pull from the list that the user inputed and I it to copy it next to the file that is uploaded to allow the team to sort by department. 

 

http://imagizer.imageshack.us/a/img922/8371/DsDrdK.jpg

 

Thanks for you help

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: When File is added to folder, Update Colomn from another list

Hi @Anonymous,

 

I have mentioned that you should add the "Update file properties" action inside your ""Apply to each 7" ,

Please modify your flow P1 to delete the trigger "When a file is created in a folder",and add the "Update file properties" action inside your ""Apply to each 7" ,as screenshot below:

Capture.PNG

 

I have nodiced that you have created in the department field with a choice type in the list, so you should choose the "department Value" dynamic content in the department field "Update file properties" action.

 

I have made a test and the flow that I provided in works.Please refer to my screenshot to create the flow and your approval process.

 

 

Best regards,

Alice

 

 

View solution in original post

4 REPLIES 4
Community Support Team
Community Support Team

Re: When File is added to folder, Update Colomn from another list

Hi @Anonymous,

 

Could you please share a full screenshot of the configuration of your flow?

Could you please share more details about the final step and where you need help?

Do you have problem update the file properties with the department?

 

I have analysis your flow and made a test on my side, you shouldn't add the trigger "When a file is created(properties only)" on your flow.

 

I have made a test on my side to create a single line of text column "department" in the sharepoint list as well as the sharepoint library, you could add the "Update file properties" action inside your ""Apply to each 7" ,please refer to my screenshot below:

Capture.PNG

 

When a new item is created as below:

Capture.PNG

The flow would run successfully as below:

Capture.PNG

 

The file would be created in the library, and the department properties would be modified as below:

Capture.PNG

 

 

Please let me know if your problem could be solved.

 

Best regards,

Alice

 

 

 

 

Anonymous
Not applicable

Re: When File is added to folder, Update Colomn from another list

List: https://imageshack.com/a/img924/3182/gFPKCC.jpg

 

Flow: P1 & P2

 

 

Hello,

 

Thanks for you reply.

 

1st step in this process is when a requester wants to create a project they would fill in a List form with the required details.

2nd: they flow choose their flow to kick off the approval process:

3rd: once approved, the file will be created in another folder in my SP site.

 

I am able to get all this done, however I'm still having probelms updating the department feild in the library/folder from the input that was submitted on the list form.

 

Folder

 

Regards,

 

Ali

 

 

Community Support Team
Community Support Team

Re: When File is added to folder, Update Colomn from another list

Hi @Anonymous,

 

I have mentioned that you should add the "Update file properties" action inside your ""Apply to each 7" ,

Please modify your flow P1 to delete the trigger "When a file is created in a folder",and add the "Update file properties" action inside your ""Apply to each 7" ,as screenshot below:

Capture.PNG

 

I have nodiced that you have created in the department field with a choice type in the list, so you should choose the "department Value" dynamic content in the department field "Update file properties" action.

 

I have made a test and the flow that I provided in works.Please refer to my screenshot to create the flow and your approval process.

 

 

Best regards,

Alice

 

 

View solution in original post

Anonymous
Not applicable

Re: When File is added to folder, Update Colomn from another list

Awesome thank you, that worked perfectly.

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Speakers, submit your sessions now! Call for speakers ends Feb. 10!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,757)