SharePoint Column Formatting – show stars that match ratings from 1 to 5

Similar to what is done in the SharePoint Column Formatting – add different mood emojis that match ratings from 1 to 5 post, let's replace rating values with corresponding number of stars. Personally, I think it even looks better. Please note, the formatting doesn't adjust any data. If you export your data to Excel, you will still see numeric values. The icons are from https://developer.microsoft.com/en-us/fabric#/styles/icons To see how it works we will create a SharePoint list, then add a “Rating” column (Number type). For example purposes, five different ratings are added with scores from 1 to 5. To add matching number of stars to the “Rating” column, click on its header – Column settings – Format this column. Once selected, there will be a Format column window on the right side. Paste the code from down below into that windows and save to get the result. { "$schema": "http://columnformatting.sharepointpnp.com/columnFormattingSchema.json", "elmType": "div", "children": [ { "elmType": "span", "attributes":…

Continue Reading

Add on-screen numeric pad to simplify user experience

If by design your PowerApps app is not supposed to have any text input but numbers then it might be a good idea to "disable" a native phone keyboard and add buttons as an on-screen numeric pad. The only downsides of this method are a bit of additional code and taking screen estate. However, it creates a smooth and consistent user experience. To disable the keyboard all text input fields should have DisplayMode set to: DisplayMode.Disabled A rough preview: The OnSelect code for each numeric button would be (example for button "1"): UpdateContext({varTicketInput: varTicketInput & "1"}) TextInput1 Default value must be set to: varTicketInput X button (to start over) OnSelect code: UpdateContext({varTicketInput: ""}) OK button OnSelect code: Set( TicketNum, TextInput1.Text ) That TicketNum global variable can be used later on any screen. NICE TO HAVE To make your app even better I would recommend disabling some buttons at certain conditions:…

Continue Reading

SharePoint Column Formatting – add different mood emojis that match ratings from 1 to 5

If you have a SharePoint List that stores some kind of reviews, usually those are from 1 to 5. Let's add some emojis that match the scores: sad face for 1 and 2 (usually 1 and 2 are equally bad); neutral face for 3; happy face for 4; overly happy face for 5. The icons are from https://developer.microsoft.com/en-us/fabric#/styles/icons It doesn't really add any practicality to the list but makes it look nicer. To see how it works we will create a SharePoint list, then add a "Review" column (Number type). Five different reviews are added with scores from 1 to 5.  To add emojis to the "Review" column, click on its header - Column settings - Format this column. Once selected, there will be a Format column window on the right side. Paste the code from down below into that windows and save to get the result. { "$schema": "http://columnformatting.sharepointpnp.com/columnFormattingSchema.json", "elmType":…

Continue Reading

Microsoft Flow – populate a multi choice field in SharePoint

How to populate a multi choice field in SharePoint is a frequent question on Microsoft Flow forum. Officially, at the time of this post there is no confirmation that such functionality exists. So I started testing possible ways of doing it and eventually came up with a solution that works and kind of makes sense. If the Trial and Error part is no interest for you, then feel free to scroll down to the Solution. TRIAL AND ERROR 1) I created a Color Choices SharePoint list with Colors being a multi choice column. Choices are Red, Blue, Yellow, Pink, Green, and Orange. Then from the list itself I submitted the 1st item with Red and Yellow values. The goal was to see how data would look like from the Flow perspective. To do that a simple Flow was created that works on selected item and gets data from it. The result was:…

Continue Reading

Add corporate or custom holidays to user calendars – 2nd method – bulk

Most companies, if not all, have their own set of holidays on top of national ones. So, distributing them is a pretty common task for an Office 365 / Exchange admin. There are different approaches out there with their own pros and cons. I’ve come up with two methods that combined give me a great result. In this post let’s focus on the 2nd method – a bulk one. I came up with this method after doing the migration from IBM Domino to Office 365. It looks complicated but after doing it several times you'll get comfortable and it won't be taking much time anymore. To see more about the 1st method (manual), please follow this link - Add corporate or custom holidays to user calendars – 1st method – manual PREREQUISITES: 1) Download and install (please use default settings) Azure Storage Explorer 2) Prepare a .csv file with all accounts using the…

Continue Reading

Add corporate or custom holidays to user calendars – 1st method – manual

Most companies, if not all, have their own set of holidays on top of national ones. So, distributing them is a pretty common task for an Office 365 / Exchange admin. There are different approaches out there with their own pros and cons. I’ve come up with two methods that combined give me a great result. In this post let’s focus on the 1st method - a manual one. To see more about the 2nd method (bulk), please follow this link – Add corporate or custom holidays to user calendars – 2nd method – bulk So, all you have to do is create a text file, change its extension to *.hol, name it with something that makes sense (e.g. 2019 Contoso Holidays.hol), put a text content similar to my example below: [Contoso Holidays] 3 New Year, 2019/01/01 Contoso Birthday, 2019/04/28 Planned Shutdown, 2019/12/31 where [Contoso Holidays] is a location and "3"…

Continue Reading

List all mail folders for a specified user to easily locate a missing folder

If you have ever seen these user requests, then this simple PowerShell script is for you: I've dragged my mail folder and now I cannot find it anymore; I've clicked on something, and now the folder is gone; I haven't done anything, but that folder was here yesterday. These types of requests are not an issue if you are dealing with a user who has several folders in addition to the standard ones. However, it's not that uncommon for a user to have a hundred of them or even more. This is when manually searching for a lost folder turns into something big. What this PowerShell script does, it shows all mailbox folders for a specified user and the path each one of those folders has. The result is shown in a Grid View that allows you to sort and search/filter. So simply search for a name your user told…

Continue Reading

Create and customize animation for controls and objects in PowerApps

Creating a functional PowerApps app is one thing. Making an app look good is another, which always happens to be time consuming. So let's try to make an app look better by adding some animation to one of the objects. My example app has two screens - InputScreen and SuccessScreen. On InputScreen I have a "Submit" button that makes a transition from InputScreen to SuccessScreen.  ButtonSubmit > OnSelect value: Navigate(SuccessScreen,ScreenTransition.None) One might say that ScreenTransition.Fade will do the trick and show SuccessScreen and its objects smoothly. That is true; however, a control you are willing to animate does not have to be tied to a loading screen. On top of that, ScreenTransition.Fade affects the whole screen. So here I use ScreenTransition.None on purpose. SuccessScreen has Label1, Icon1, and Circle1 objects. Let's add some smooth animation to that circle object and make that animation work as soon as SuccessScreen is visible. To…

Continue Reading

List all Corporate Contacts and Distribution Lists they belong to

There are times when your company needs to keep a list of Corporate Contacts that are used by your own users on a daily basis. You can find them in Microsoft 365 Admin Center - Users - Contacts or Exchange Admin Center - Recipients - Contacts. It gets more complicated when those contacts are added to several Distribution Lists, more so when they are mixed with your users. The issue is that unlike working with Internal Users, you cannot open a contact and see which groups it belongs to. This is where PowerShell comes handy. The script below finds every single contact and all groups it belongs to (if any). To show the result I use a Grid View (Out-GridView) because it provides an easy column sorting and filtering. This script might help to find a user error if some contact should or should not be in a group. Side…

Continue Reading
Close Menu