When you’re working with multiple choice tags in SharePoint, they have a tendency to shrink to fit, causing the tags to get “cut off” with an ellipsis if you have a lot. There’s a super easy fix for this – just set your view to auto-fit height in the view selection menu! Here’s the result:… Continue reading: How to make choice tags “wrap” in SharePoint
Creating tasks in a system that allows interaction with said tasks (e.g. checking a box to complete) can be really tedious and time-consuming – this makes it a perfect target for AI automation! My issue is that most of the AI tools designed for this across all the systems I’ve tried are currently half-baked, meaning… Continue reading: Using AI to Create Tasks
What’s new and interesting in the world of Power Platform? Power BI From the Power BI Core Visuals vision board: Sidenote, the vision board linked above is also a Power BI report itself – @Power BI Park has a “reverse-engineer” tutorial here. In other Power BI / Fabric news, org apps were also released recently, allowing multiple… Continue reading: December 2024 Power Platform News
I used Notion, and I liked it. There… I said it. Here’s why. If you’re not familiar with Notion, but you ARE familiar with Microsoft products, Notion vaguely resembles a combination of Microsoft Loop and SharePoint Lists. This is a strangely emotional topic for me, because my career is based primarily around Microsoft 365, but… Continue reading: Notion vs Microsoft Loop & Microsoft Lists: A Comparison of Features
YES you can use incremental refresh on SharePoint files in Power BI! The trick is, the date column you use needs to be something OUTSIDE the file, such as the “created date” column in the SharePoint library. What that means, is, this is only really useful for SharePoint folder sources, where Power BI is grabbing… Continue reading: Can you use incremental refresh on SharePoint file sources in Power BI?
Early on when the SharePoint Online List 2.0 connector was released, I did some internet searching to see why you’d use the new connector vs the old connector. It turned up a lot of posts like this, where it was stated that the limit on the 2.0 connector was a maximum of 5000 returned rows.… Continue reading: SharePoint List 2.0 Power BI Connector: Is the Limit 5000 Rows?
It depends on exactly what functionality you need, who your form submitters are, and what licensing you have available to use. Are your form submitters internal organization users or anonymous/external? If your submitters are external and not being explicitly invited with their Microsoft 365 accounts, the answer is going to be Microsoft Forms or Power… Continue reading: Which tool should I use to make a form in Microsoft 365?
If you’re using SharePoint lists for any kind of ticket or request management, you are likely to want to track how long it took to complete the request. We can do this automatically using Power Automate to set a “close date” date-type field. First, make sure you have a “close date” or “completion date” field… Continue reading: Tracking “days to complete” a SharePoint list item request
A good Power Automate approval flow has the following: This article is part of a series on doing request management with Microsoft Lists, so you might check that out as well! Power Automate makes it really easy to make a basic approval flow, but unfortunately it comes with none of the above out-of-the-box. I would… Continue reading: How to design a GOOD Power Automate approval flow
Comments in SharePoint are a bit of a can of worms. There’s two types of comments: Modern comments My issue with the new modern comments is that they do not exist as real list data to be referenced by Power Automate or any kind of automated notifications. People interacting with the items only get notified… Continue reading: Techniques for managing comments in SharePoint lists