Unanswered

Use Flow to Create New List in Sharepoint Online

(3) Share

Report

Posted on by Community Power Pla...

I know I can use flow to create a new item in a different list whenever a new item is created in the primary list, but is there any way to create an entire NEW LIST when I create an item in the primary list?

Example:

- I have a list "Inspection Database"

- When a new inspection is expected, I add an item here.

- Each new inspection needs a request log created (a separate list for each inspection).

Can I have that new request log automatically created based on a template whenever I add an item to "Inspections Database"?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

v-yuazh-msft on at

Like (0)

Report

Hi @ danherring,

Creating list in sharepoint is not supported in microsoft flow currently,

I afraid that there is no way to achieve your needs in Microsoft Flow currently.

If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Regards,
Alice Zhang

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

I agree with @v-yuazh-msft but you might want to consider an alternate solution:
1) Create a Log list that includes a lookup column that refers to the primary list. I suggest making the lookup column a required column
2) When a new entry is created in the Log list the user will be required to select the item in the primary list to which the log entry relates
3) Create views in the Log list that group by the lookup column. You may want to create additional views as well such as a view that only shows recent log entries, etc..

Was this reply helpful? Yes No
JimmyW 2,563 on at

Like (2)

Report

Yes you can.
You need to create a Azure Function app and use powershell. You then call the azure function app in flow and it will run the powershell command to create the library or list from a template. Stp file.

Was this reply helpful? Yes No
JimmyW 2,563 on at

Like (3)

Report

If its no need for a template you can create a list from a Send an HTTP request

Was this reply helpful? Yes No
RyanGilreath 45 on at

Like (2)

Report

Would you happen to know of a resource that explains either the HTTP request to create the list or the Azure function mentioned in your previous comment?

I have a similar need as the OP and would like to have a new custom list created.

Was this reply helpful? Yes No
JimmyW 2,563 on at

Like (1)

Report

@rgilreath
https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-lists-and-list-items-with-rest

https://michalguzowski.pl/create-sharepoint-list-using-flow/

For the Azure part you create a runbook based on powershell and then use New-PnPList to create the List where you want it.
Example of a azure runbook that creates a list in the site you input. After you created the runbook you will use the trigger called Create job in flow and call the runbook. The runbook will ask you for Title of the list and on what site you want it to be created at. You have to setup your own credentials.

{
            param (
        [Parameter(Mandatory=$true)]
        [string]
        $Url,

        [Parameter(Mandatory=$true)]
        [string]
        $LibraryName
    )

$cred = Get-AutomationPSCredential -Name "xxxxxxx";
Connect-PnPOnline -Url $Url -Credentials $cred;
New-PnPList -Title $LibraryName -Template DocumentLibrary -OnQuickLaunch
}

Was this reply helpful? Yes No