One thing that has been bugging me recently is being able to get a list of all my Office 365 SharePoint group sites all at once. With the new SharePoint Admin Centre due to be rolled out any time now, this will soon be a solved problem, but i just want a list of all the sites i’ve created now, should be simple right?
An easy way to get a list of all SharePoint Online/ Office 365 group sites
There are ways online to do this using PowerShell, but surely there has to be an easier way…here’s what I did:
Navigate to the Office 365 SharePoint group sites landing page
Click in the search bar – press enter to start a search
In the all results type filter – change to sites
Bingo! All of your SharePoint sites are now showing, you’ll notice that the classic sharepoint sites and Office 365 SharePoint group sites are both included in the results, which is exactly what I wanted.
This is the final part in my fun with PowerApps series, in this post i’ll go through the steps involved in creating a new PowerApp from scratch and highlight some of the difference with using a template or generating a PowerApp from a SharePoint list.
You can read all the other parts in this series below:
So far we have generated our very first powerapp from a SharePoint list or library, but now we want to take it a step further and create a brand new PowerApp from the beginning to enable us to create a desktop experience.
To create the bespoke PowerApp we will need to begin in the PowerApps studio, the steps below walk through creating the bespoke PowerApp:
In the Home screen, select Start from blank – make sure the desktop view is selected – Press Make this app
The PowerApps studio will give you some useful tips on how to create forms or galleries which are definitely worth checking out if you haven’t already!
On the canvas, press Connect to data
In the Data window, select the data connection we created earlier
Enter the URL of the SharePoint site you want to access
Once entered, you will see all the available lists and libraries you can use as the primary data source, select the one you wish to use
And there you are your custom PowerApp is all set up and ready to go! Of course this is just the very beginning and you now have the fun bits to come like adding all of the elements that will make up your PowerApp but from my experience I think there are a few approaches to achieve this.
My idea was to create and open up the template helpdesk PowerApp side-by-side with my custom one to get a better understanding of how to re-produce things like the totals across the top and some of the finer details that make up the PowerApp. I think doing it this way is much easier than trying to pick apart the templates as you are starting with your own data source rather than the static ones provided within the templates.
As well as the desktop and mobile experiences you now have the ability to create list forms using PowerApps too, so now there is even more fun to be had with PowerApps!
Carrying on from my last post – creating a data connection, we are now good to go and begin to build our first PowerApp!
Just like setting up the data connection, creating a PowerApp can be a really simple thing to do.
However, I’ve found either creating a PowerApp from the SharePoint list or library is really quick and easy, but it doesn’t necessarily give you the most flexibility when it comes to wanting to do it your own way…
Creating a PowerApp
You can create a PowerApp from a list or library literally from the push of a button! Its as simple as:
Create your list or library, add all the associated columns and data you wish to be displayed in your PowerApp
Press the ‘PowerApps’ button on the list menu, then press ‘Create an app’
You’ll then be prompted to create your app, start by giving it a name and press ‘Create’
After a few moments your app will be created! It will open in the PowerApps web editor and you should see your list columns and data displaying in your shiny new PowerApp!
You can also take a look at the app in the preview to get a good look at how it operates and how the data is displayed…
That’s it! Your all set…but if you’re like me you’ll have some questions. Like, what if I want a desktop app and not a mobile one?
Well for that you’ll need to build an app from scratch, I’ll be going over creating a new PowerApp in the next part of this series so hold on as i’ll be posted the next part very soon!