Create SharePoint List using Power Apps and Power Automate

Learn how to create a SharePoint List and add columns to it using Power Apps and Power Automate. This is done by calling the SharePoint Rest API via the SharePoint HTTP action in flow. You will use a Power Apps app that allows you to dynamically provide the list name, the column names, column type (FieldTypeKind), and required or not. Then you will save your choices in a collection that is sent to Power Automate flow via the JSON function. Once in flow you will use Parse JSON and Apply to each to loop through the array and provide values to the SharePoint HTTP actions. A little nerdy but some great skills to learn.

00:00 It starts
01:47 Demo of creating a SharePoint list and Columns from Power Apps and Power Automate via the SharePoint HTTP action
04:12 Create a SharePoint list with Flow
06:32 Bonus tip how to change it to create a document library via the REST ApI
06:52 Parse JSON Action
08:49 Apply to each through the arrary of columns that need created
09:52 Adding the columns to the SharePoint All Items Default view
10:34 Power Apps create a collection OnStart for the JSON Values and options
12:12 Combine Static and Dynamic data to generate the BODY JSON
15:05 Generate Choice column array of results
17:22 Power Apps Split Function
19:44 Power Apps JSON Function to convert a collection into an array
21:28 View the results of the flow run in studio
24:02 Use Case ideas including approving the list, adding additional static column values, and maybe even list copying

Microsoft FieldTypeKinds

[innoviv]

So far I've only listened to your lead-in for this video but I just have to comment. I'm formulating a Canvas App / Power Automate tool and wondered, "Maybe Shane has something on this." What you said in the lead-in is exactly what I want to do! Simpatico. Keep up the great work. And now I will watch the video.

[midnightmadness]

just an FYI, getbytitle('All Items') has a whitespace, but its not clear because of the text wrap in the video, thanks Shane, this was helpful and saved me time.

[mundopower]

Hi Shane, thanks a lot!

Is it possible change the column Title to not required and remove from the listview, using automate?
I tried to remove, but the metod removeviewfield to this "Title" column doesnt work.. but the main necessity is to remove the required to "Title"...

[turtleturtle]

This is good stuff. I am love it! Keep them coming.

[cvkealey]

Fantastic stuff! I spent more time than I'd care to admit digging through the various documentation on this (specifically the SP HTTP request details/syntax) over the last few days for another project. There are some specifics (e.g.: how to make a "date only" date-time field, or a "person or group" person field) that were a pain to figure out.

[ralphcabrera]

Hi Shane, is there a way to have an excel template to new sharepoint list with power automate?

[Jezerypamela]

Hi Shane! Is it possible to create the list and also add a few records to it? Not just columns? If so, can you please give me general guidance

[branzo]

Thanks for the video. Would this concept work for connecting azure active directory data with power apps to SharePoint list? Doesn't seem to be clear info to pull from AAD to build, say, a staff directory with AAD meta data.

[JONODO]

Hi there, just wondering if there is a way to remove the requirement of the Title Field via Power Automate?

[TheSoyerTube]

Hello thanks for this Advanced tutorial its awesome! if a build this app and a ADM-User can create Lists, How i can made those created lists by powerapps appear in this app, to show for other user answer the list and input information

[petrinnn]

Shane, you are awesome.. thanks a lot!
Do you know how to change the column Title to not required and remove from the listview, using automate? i tried to remove, but the metod removeviewfield to this "Title" column doesnt work.. but the main necessity is to remove the required to "Title"...

[nealconyard]

This is great, is there a way to also set an app to then use the generated list as a data source?

[isaiaguillon]

This is great! Is it possible to add this list to power apps as data connector using power automate?

[josemanuelortuno]

Good job Shane, I'm learning a lot from your videos! A question: could it be possible to create a set of different lists for each user of the app? I mean, instead o sharing my app and 20 lists for every user of the app, on the first run of the app, create the requiered lists in the user sharepoint site. Thanks.

[johnleone]

Can you plz send me the test you used at 7:45?

[NaveenKumar-qrnm]

Hi Shane, i am following your videos and it was very helpful to me. Thanks for the videos.
I have one doubt here, How can we validate if list name already exist?

[karolinaunderwood]

All works fine and perfect. However, newly created list is not displayed by default in Quick Launch. Any chance of updating the flow to enable the List automatically being displaced?

[latrobe]

Brilliant as always Shane. Would this apply to simply adding a new column to a current list?

[barajasjj]

You're my hero, Shane!
Is there a way to update a list item using Power Automate without knowing the item's ID? I want to kick off a flow when an item is created in list A, then using key information from the item created have the flow create an item with the same information in list B.

[shubhamgade]

Hello,
How many no. of collection we can create in the a Poweapps? (Maximum)
I am working with SQL table having huge data.