Dependant Controls: Switch between Comboboxes and Text Input in PowerApps

In this post, we’ll make your app flexible when it comes to enter data. More specifically how we can switch between a combobox and text input. I’ve build an app for a customer where a user needed to choose between defined values (combobox) and his/her own value (text input). Of course, we’re also going to see how to send this data back to the data source (SharePoint in my case) depending on the controls and values chosen!

The different types of tabs to add in Microsoft Teams when using PnP PowerShell

In this blog post, I wanted to talk about the different types of tabs you can add in Microsoft Teams when using PnP PowerShell. More specifically about the -Type parameter which offers multiple values, but also because we have a dynamic parameter for the Add-PnPTeamsTab cmdlet. The easy ones… Most of them are pretty self explanatory. For instance, -Type PowerPoint or -Type WebSite. We also provide an example in the Add-PnPTeamsTab documentation for the PDF type.

Warn users about loosing entered data when navigating to a different screen in PowerApps

One way to improve user experience, and increase adoption to a certain level, is to add “little” things that would help users. In this blog post, we’re going to create a popup that will warn users when they want to navigate to another screen, BUT they’ve already entered data. Let’s offer them the choice to “Leave” or “Stay”. Scenario I have an app for rewarding employees once they’re nominated by their colleagues.

Remove specific characters from values in PowerApps

Have you ever had the scenario where, you had values in SharePoint (or Dataverse) with a character, or the end of the value is not relevant for your app, and it should not be displayed? I did. In this first PowerPlatform blog post, we’ll get rid of the end of the value that’s after a specific character. And we’ll also include getting rid of the character since it won’t be relevant nor nice to see anymore!

Limit OneDrive For Business access to Security Groups

A new feature to use very carefully! OK, you’ve been warned now 😉 In this blog post, we’ll have a look at how we can limit access to OneDrive For Business, and the impact when enabling this feature. Scenario Let me lay out the environment first, so we understand the impact later. In this example, we’re going to have the following: 2x users (Adele & Debra) 1x Security Group called “SG-Consultants” Both users have OneDrive For Business provisioned, with sample content (private or shared with others) 1 of those users (Adele) will be a member of the Security Group we’ll be using, but not the other user (Debra)

View Private Channels in the SharePoint Admin Center

Finally! We can now see how many Private Channels a Microsoft Teams Team has, directly from the SharePoint Admin Center! As a reminder, when you create a Private Channel, it creates another SharePoint site with different permissions. Meaning a Team could have many other SharePoint sites that we couldn’t see, and therefore, do “things” that would have been regrettable! In this short and sweet post, we’ll see where to find the information about Private Channels in SharePoint Online.

Share files in SharePoint in review mode only

In case you haven’t seen, there’s a new feature when you share a document from SharePoint Online: Open in review mode only. In this blog post, we’re going to have a look at how it works, and what’s the experience from a reviewer perspective. How does it work? When you’re about to share a document, you’ll see the option in the popup. You must have allow editing checked, or the option will be greyed out.

Set default values for SharePoint list items

There are so many features in SharePoint (on-prem & online) that some may be overlooked. Lately, I was working on a PowerApps with Power Automate in the background, and I needed to set default values for some items’ fields, and surprisingly, my first thought was to set those values within the flow. But I have noticed a couple of things by doing it this way. First, that Power Automate was slow to set the value, and second, it was also adding a new version (i.