Blog

4 Functions to Simplify Date & Time in Power Automate

My most recent Power Automate builds have included a lot of work with date and time data. I thought this would be an excellent addition to the Getting Started with Power Automate series I started a few months ago. This is also a great starting place to learn about expressions. Read on to learn more about four functions that will help simplify working with date and time in Power Automate.

Read More »4 Functions to Simplify Date & Time in Power Automate

How to Find SharePoint Site, List, and View IDs for Use in Power Automate

Since I started working with Power Automate, I’ve needed to find various SharePoint IDs. The first time this happened, I wrote a post. Since then, I’ve needed to look up a couple of other IDs, so here’s a more comprehensive explanation. If there are more IDs I need to find, I’ll just update this post. I was surprised to find the advice online for this to be mixed and at times inaccurate, so I thought this was worth writing. Read on to learn more. You might want to bookmark this one.

Read More »How to Find SharePoint Site, List, and View IDs for Use in Power Automate

Automation with Excel, PowerBI, Power Automate & Alteryx! What Could Go Wrong?

One of our users was manually entering data into a spreadsheet every single day rain or shine, weekday or weekened, vacation or not. She needed an automation solution, and I built one for her. But, we ran into a small but time-consuming problem to solve. The automation added data to an Excel spreadsheet, but the updated data didn’t appear in PowerBI. Half the battle was figuring out whether Excel, PowerBI, Power Automate, or Alteryx was causing the problem. Wanna guess which one it was? Read on to find out.

Read More »Automation with Excel, PowerBI, Power Automate & Alteryx! What Could Go Wrong?

What Can Power Automate Do On Mobile?

My Learning Power Automate series is coming to a close, and the last thing we are investigating is the power of Power Automate on mobile. I was searching the Templates section of Power Automate for inspiration, and I found a template with a manual trigger to send a notice to your coworkers that you were out sick. So, you might wake up one morning and feel like death. All you have to do is grab your phone, make a few clicks, and you can go back to sleep. That’s pretty cool right? Well, I made it even better with a few tweaks. Read on to learn more about Power Automate on mobile.

Read More »What Can Power Automate Do On Mobile?

How to Find Planner IDs for Power Automate

Power Automate integrates really well with other Microsoft applications like Teams, SharePoint, and Planner. Most actions involving these applications use drop-down lists where you can choose from a list of SharePoint sites or Teams. But, the drop-down list is NOT a list of all the Teams/SharePoint sites/Plans that you have access to. So what do you do when what you need isn’t in the drop-down list? In a prior post, I explained how to find the necessary ID for SharePoint. This post shows how to find Planner IDs to reference a specific Plan in Power Automate.

Read More »How to Find Planner IDs for Power Automate

How to Understand Code in Power Automate

I’m working on bringing self-service automation to my company with Power Automate. Next week, we learn about processing email. To this point, I’ve avoided talking about code. I’ve stuck to dynamic content and things you can build with the user interface. But, to process email, we need to talk about code. So, if you’ve ever been confused by what you see when you click on the Click to download or Show raw inputs links, this post is for you. It will provide that foundational knowledge to work with code in Power Automate.

Read More »How to Understand Code in Power Automate