Stephanie and I are data people. We excel at taking loads of unstructured data and making it intelligible (see what I did there?!). Do we want to be working with unstructured data? Is Excel a data collection tool? Or better yet, is Excel a database? In theory the answer to all of these questions is… READ MORE
I finally did it. I created a function I’ve been wanting to be able to use for *years*. Test-RsRestItemDataSource is here. I can’t tell you how many times I’ve started to work on a report I was told was working, only to find the connection info was invalid. This wastes valuable time, especially when you’ve already made… READ MORE
Recently while developing a flow for SharePoint list process, I came across a requirement to set unique permissions for SharePoint list items. So, in this blog post I will share a walk through on how to set unique permissions for item in SharePoint using Power Automate. Walkthrough In your flow add the actions as per… READ MORE
A few weeks has passed since Microsoft Ignite and me and Amanda last spoke about our two worlds colliding. To refresh your mind; Amanda is working with productivity, collaboration and Microsoft 365 and you can find her blog here. Our previous common article had the title “The best from both worlds – Office Apps & Services and BizApps combined”. Our… READ MORE
How to overcome the Power Automate Approvals 30 days limit post is my attempt to show how to deal with this Flow annoying 30 days limit. General idea of approach First Flow – create new Audit item Second Flow – track Approval Trigger conditions Wait for an approval configuration Timeout configuration Approvals reminders consideration Flow result… READ MORE
We are delighted to invite you to join us for Power Platform Week [8-12 March] – one unmissable week of free online Power Platform Learning across a variety of blogs, eBooks, webinars and how to videos gathered from the Microsoft Power Platform team and leading independent community experts, to help you keep up and get ahead on all things… READ MORE
Storytelling is a very human phenomenon, which goes back tens of thousands of years to when humans first gained the ability to speak. In this session we explore a Power Platform Solution that has the capability of telling compelling stories through text, images and Power BI. With these resources at our disposal we can begin… READ MORE
Microsoft PowerPivot is a free add-on to Excel from Microsoft that allows users to produce new kinds of reports and analyses that were simply impossible before, and this book is the first to tackle DAX formulas, the core capability of PowerPivot, from the perspective of the Excel audience. Download 2 Chapters: 8 – CALCULATE() –… READ MORE
The project If you’ve been reading my posts, you may know by now, that I’m often trying to find out ways to push the limits of the Power Platform in its citizen developer statement. At the recent MS Ignite conference there’s been a few changes and features releases. 2 of those features are focused in this article:… READ MORE
In part three, we chose a random (yet meaningful) birthday quote and ran it through a modified approval process, and we also started the process to choose the send-method for our birthday wishes. Today, we’ll cover two of the methods and how each one processes the information and actually sends the wish out. Let’s get… READ MORE
