SharePoint List item to create SharePoint library document folder in relevant library with copied details.

Like (0) Share

Report

Posted on 29 Jun 2022 19:07:22 by 43201

Hi all,

Seeing if its possible to build a flow to copy content from SharePoint list item-> create a folder in a document library and copy the list content from select columns into the same columns on the newly created file.

Essentially I have a master list where details are added under specific columns. I want to on creation create a folder with the same column details in a specific document library in the site based on an identifier. The columns and data pulled each time do not change only the identifier to signal where to create the folder which is set when the list item is created.

Eg. This copied

To this

Just minus a few columns that aren't required for the library.

Any help would be appreciated.

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

ryleybauer 327 on 29 Jun 2022 at 19:36:24

Like (1)

Report
Re: SharePoint List item to create SharePoint library document folder in relevant library with copied details.

This is definitely possible.
Make a flow:
Trigger: "When an item is created"
Action: "Get item" (by ID from the previous step)
Control: "Switch"
Create a case in the switch statement for each folder
Action: "Create new folder" step under EACH case, set to point to each specific library to match the condition
Action: "Update file properties" step under EACH case, and use the "ID" from the "Create new folder" step
If you want to get fancy, you could use library GUIDs to make the flow less dependent on each library being predefined as a case in the switch statement. The Create Folder action can take a library name or library GUID (GUIDs are usually better as they don't get broken if lists are renamed or have characters that are substituted like spaces). You would probably be best making a second list with a column for library name and a column for the GUID of the library (it's at the end of the URL if you open the library settings). Then, on your Required RA's list you would add a lookup column to select which library it goes into and if you include the GUID in the lookup columns then you should be able to use it directly from this flow to dynamically specify which library to create the folder.

Was this reply helpful? Yes No
43201 19 on 29 Jun 2022 at 20:13:17

Like (0)

Report

Re: SharePoint List item to create SharePoint library document folder in relevant library with copied details.

Thank you for your response, I'll stick to simple at this stage and work up to fancy! I'm fairly new to Power Automate, if you could clarify a couple of things that would be awesome.

I've followed those steps and created the below.

This works like a charm and creates a file with the title in the relevant library but how do I add the addition column details to the relevant columns on the new file?

Also this is an addition but if the details in the SharePoint list columns are updated at some stage after the initial creation of the folder, is it possible to have them automatically update the columns on the existing folder?
Thanks so much for your help!

Was this reply helpful? Yes No
ryleybauer 327 on 29 Jun 2022 at 21:00:47

Like (1)

Report

Re: SharePoint List item to create SharePoint library document folder in relevant library with copied details.

Hey,
You'll have to add an additional step for "Update file properties". As far as SharePoint libraries are concerned, "Files" and "Folders" are both "Files" or "List Items".
If this helped, do you mind marking the other reply as the solution?

Was this reply helpful? Yes No