/images/profilepic.jpeg

Get ALL SharePoint sites info using an App Registration (in EntraID) and Power Automate

 

Imagine the possibilities when you can call an API; You’re not “stuck” to only whatever is built for you. Of course, you need to expand your skills a bit on the “developer side”, but it’s really worth it. I, for one, am on the “admin side”, but the more I work with the Power Platform or even PowerShell, the more I can see the amazing solutions I can build! 😊

With that being said, in today’s post we’re going to look at how to get all the SharePoint sites (aka Site Collections) in your tenant, using an App Registration in EntraID, and Power Automate. Let’s do this!
 

Get Data in App after Scanning a QR Code

 

When we build apps, we should always have the user experience (UX) in mind. Either from a design perspective to make it accessible, beautiful to look at, or streamline the process the app is used for.

In today’s blog post, we’ll see how we can use a QR Code (generated for free!) to feed the app with the required data, thus reducing inputs from users. Let’s do this!
 

Scenario

There are multiple scenarios that would benefit from using a QR Code. In general, “Incidents Reporting” is a very good one. You’d have your assets (i.e.: computers, meeting rooms, Surface Hubs, company phones, etc…) all with a sticker, and referenced “somewhere”.
That “somewhere” can be an external system, Dataverse, SharePoint, or others (depending on the volume), and will store all the necessary information with regards to the asset.

Prevent Users From Sharing Files in a Site

 

In today’s blog post, we’ll discuss a SharePoint setting that will prevent users from sharing files even if they’re part of the Members group. Furthermore, the experience is also different if the Access Requests feature is turned on or not!

This setting is to be used wisely if you don’t want to create frustration amongst your users 😅
 

Permissions

Wether you manage a SharePoint site associated with a Microsoft Teams Team, or a standalone site (with M365 group or not), there will be a default Members group . Meaning the users in that SPO/M365 group will be able to share documents and the site itself.

Pass a Value From Buttons to Next Screen

 

Isn’t it useful when you can pick up a value from a control, and move along to other screens with that value to continue your journey nicely? It is. So today’s post is about grabbing a value from a button, and moving on to our next screen.

Scenario

In our scenario, we’re going to be reporting issues for assets (screens, computers, etc).
So we open our company app, and we go through the process of describing the problem. Along the way, we make some selections (using buttons), and those values should be sent to the support IT team to resolve.
 

Show or Hide Fields depending on Radio Buttons Value

 

A good experience when it comes to building apps, is to make sure we don’t display irrelevant information to the users. Sometimes screens are overwhelming, we don’t know where we should click or select, why are greyed out fields on the screen?? We even start wondering if we’ve filled the form correctly…

Today’s post is about displaying only the necessary information for the users to fill, via Radio buttons in Power Apps.
 

Add the Manager automatically using Power Automate

 

Many times in our automation processes, we need to add the Manager of a specific user. Sometimes it’s just for reference, or the process will require an action from the Manager.

Today, we’ll see how to add the Manager automatically in SharePoint using Power Automate.
 

SharePoint list

I have a SharePoint list called Employees containing (at least) 2 columns:

  • EmployeeName
  • Manager

Both columns are “Person or Group” fields.
 

/images/powerplatform-screenshots/add-manager-power-automate-img1.png

Spice up Your Navigation with Modern TabList Control

 

Another post about how to improve the looks of any given app! We’re used to have buttons for the navigation, this is the classic way of doing things and it works very well of course.

But when Microsoft released new modern controls, the TabList control is pretty awesome to create our navigation 😁  

Connect the TabList control

When you add the TabList control, you can connect to a data source, or you can insert the values directly into the Items property of that control.

Create a pills-like effect in Power Apps galleries from multiple SharePoint lists

 

Today, we’ll create something visually useful for our galleries 😁 How about “something” that would make us recognize what type of training we’re looking at, quickly, and at a glance? Sounds great BUT we may have a couple of possible scenarios depending on how our source data is structured.
 

Let me explain.  

Scenario 1

Let’s imagine our company built an Power Apps app for users to browse trainings available and we display the catalogue over a gallery.