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"?

All responses (6)

Answers (0)

JimmyW 2,563 on at

Like (1)

Report

Re: Use Flow to Create New List in Sharepoint Online

@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
}
RyanGilreath 45 on at

Like (2)

Report

Re: Use Flow to Create New List in Sharepoint Online

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.
JimmyW 2,563 on at

Like (3)

Report

Re: Use Flow to Create New List in Sharepoint Online

If its no need for a template you can create a list from a Send an HTTP request
JimmyW 2,563 on at

Like (2)

Report

Re: Use Flow to Create New List in Sharepoint Online

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.
ScottShearer 25,228 Most Valuable Professional on at

Like (0)

Report

Re: Use Flow to Create New List in Sharepoint Online

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..
v-yuazh-msft on at

Like (0)

Report

Re: Use Flow to Create New List in Sharepoint Online

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

Community site session details

Use Flow to Create New List in Sharepoint Online

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

Use Flow to Create New List in Sharepoint Online

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates