This is a little script that works on classic SharePoint lists (modern lists, you should really use PowerApps to customize it). It'll allow you to format a field row, label or the cell the value is in. Similar to: Yes, it's ugly, but I wanted to highlight it plainly: formatRow - allows you to format... Continue Reading →
Integration: Case management in Salesforce, documents in SharePoint
We created a folder creation process to store case files in SharePoint and giving users the full breadth of document capabilities of SharePoint.
Tips to entertain your users while PowerApps gets their data, i.e. loading screens
Depending on where your data lives, it may take a few seconds for that data to display in the PowerApp. There is nothing that drives users more nuts than just staring at a screen as it does nothing, wondering if it's frozen or broken. PowerApps does have that useless little loading dots thing at the... Continue Reading →
Tips and tricks for working with Microsoft Flow
I Love Microsoft Flow I don't know what it is, but I spend a lot of time in it, from small silly Flows to real time savers. I've shared a few of my Flows already, and will be sharing more. I may be a little addicted to automation, Flow being the biggest contender, but also... Continue Reading →
Best practices for managing controls in Microsoft PowerApps
Microsoft PowerApps is a great "no code" solution for creating customized forms for SharePoint Online and independent web apps and mobile apps. However, it can get unruly inside of an app if you don't follow some sort of guidelines and practices. After you get a few screens in with dozens and dozens of controls, you... Continue Reading →
Custom Style Sheets for PowerApps, pseudo CSS
Yes, CSS for PowerApps, kinda. Actual CSS based style sheets are not possible, but the next best thing is. We can create a few objects to store our styles in, like colors, font sizes, dimensions, etc. and then reference them across the app. Not really cascading style sheets, but let's call them just style sheets.... Continue Reading →
Use Microsoft Forms to collect data right into your Excel file
This post is the first of a few where we look at how easy the Office 365 stack integrates. In this series, we will: Create a Form and have the data save directly in Excel (this post)Add the Form to Microsoft TeamsNotify the Team a submission was madeHow does this look like on the phone I... Continue Reading →
Customizing SharePoint’s Modern Lists’ Forms
Ya know that awesome new interface we get in Office 365 called Modern Lists? Ya know how that's not editable, or customizable, or extensible? Well, ya know it right! It's not. However... Above is a typical modern list, in all of it's glory. Pretty right? But I want to add some of my own code... Continue Reading →
Embedding your JavaScript into a SharePoint page
A very typical approach for client side development in SharePoint is to throw the code onto the page where you need it. You can alternatively put into the master page, but generally speaking, most code doesn't need to run on each and every page. The following describes my preferred, tried and true, method of handling this.... Continue Reading →
Showing users’ profile pictures in a SharePoint list
Special thanks to Joann for the question! A common use case is to have a list of people in a list in SharePoint, maybe they're members of a project, contacts for a department, your favorite people to talk to, whatever it may be, you have a list. This example is a listing of my teammates: Now I'd... Continue Reading →