/images/profilepic.jpeg

How to protect your App Secrets in Power Automate Desktop

Securing any type of credentials, anywhere, is very important. Simply imagine testing a flow with someone looking over your shoulder? What about running that flow and see in plain text the content of the variable? Would you be happy if your API Key was accidentally visible? No. In this blog post, we’ll see how we can protect our app secrets when building a Power Automate Desktop flow, and which one is better.

Add Teams Owners and Members with Power Automate OR Power Automate Desktop!

Today we’ll learn how we can add Microsoft Teams owners & members from a spreadhseet hosted in SharePoint using not only Power Automate (cloud) but also using Power Automate Desktop! Two posts for the price of one 😁 Common Artefacts For both scenarios, we’ll use a spreadsheet called “New Joiners.xlsx” from SharePoint. This excel file contains 2 tabs: PA –> data for our cloud flow PAD –> data for our desktop flow Both are transformed into a Table in the Excel file Cloud Flow (Power Automate) Ideally, you’d want to probably have a automated or scheduled trigger.

Say NO to creating the same SharePoint item TWICE with PowerApps

One thing that is pretty nice in SharePoint is that, you cannot have a file with the same name in the same location (library). Unless it has a different extension: For example, sample.docx and sample.pdf can coexist in SharePoint. But you cannot have twice sample.pdf. However, you can have the same ITEM name in a SharePoint list! Wouldn’t it be useful to not have “duplicates” in a SharePoint list when submitting data from PowerApps?

5 things to think about FIRST for better apps

Sometimes we’re so excited to be building something new that we open PowerApps Studio, and start dropping buttons, labels, comboboxes, forms, etc… But then, we find ourselves in tricky situations when we need to move elements, the theme is not correct and we need to amend each control, more fields need to be added on the screen but we’ve got no more space, or worse… the data should have been in Dataverse and not SharePoint!

Avoid special characters in Text Input in PowerApps

Today’s post is about something many app makers are trying to prevent users from doing when not necessary. And that is, adding special characters in text inputs, especially when a Power Automate flow is involved in the background! 😁 Personally, I’d rather stop the issue at the source (PowerApps) than messing around with the flow(s). So, if you know that special characters are not needed, this post is for you!

Add an admin account to the users OneDrive for Business (via UI)

In this blog post, we’re going to add an admin account into a user’s OneDrive for Business via the interface (UI) in 2 different ways. There might be situations where you need to have access to the user’s personal area (aka OneDrive for Business). For example, you might need to create folders pre-migration, or quickly “audit” something. The below 2 methods require you to have an admin account (i.e.: SharePoint admin, or Global Admin) as we’re going to use the Microsoft 365 Admin Center & the SharePoint Admin center.

Make your Power Automate Desktop flows cleaner with subflows

Subflows in Power Automate Desktop are a way to isolate some actions out of the Main flow. This has many benefits: Main flow is cleaner Repetitive actions can have their own flow Can be used as “branching” (more on that later) Where can I create subflows? When you open the Power Automate Desktop designer, you’re landing straight into the Main flow tab. If you look on the left of that tab, you’ll see “Subflows” as a dropdown menu.

What are the different ways to modify the users OneDrive for Business storage quotas?

Did you know there are multiple ways to update or modify your user’s OneDrive for Business? In this blog post, we’re going to go through 3 methods! Hopefully that will give you sense of where to go depending on your role/permissions within Microsoft 365. Microsoft 365 Admin Center Probably the most obvious way is the Microsoft 365 Admin Center. If you navigate to Users > Active users, you can select a particular user by clicking on their name, and then a panel/blade opens on the right handside.