Posts

Showing posts from April, 2021

How to reset a datepicker control in PowerApps?

Image
 Scenario: Simple reset a date picker control. Issue, you can't use normal Reset() function to reset the datepicker control. Solution: Simple create a variable Set(varResetCD, True) and use this variable to update the reset property of DatePicker control. The below Reset() won't work in case of datepicker control We need to create a variable and use it at the Reset property of the datepicker control. Also, if you still see some text inside your date field there are two other places you need to check in one is the datepicker control advanced properties. In the above screenshot all you need to do is clear InputTextPlaceholder. And then select the control and check the DefaultDate property of the date.  This should be set to Today(), you can also change it to something like below If(varResetCD,Blank(),Today()) What this does is sets the control to blank if the variable you have declared above is true. 

M365 Licensing

Image
 M365 is  a per user licensing option that includes  O365 Windows 10 Enterprise Enterprise Mobility + Security M365 is available in 2 options Microsoft 365 E3 & E5. Fetching M365. LICENSE Microsoft 365 Full USL Microsoft 365 Add On Microsoft 365 "From SA" USL Microsoft 365 Full USL New Enterprise Agreement/ New Enterprise Subscription customers who want to license the Enterprise Platform as cloud services on a per user basis. Existing Enterprise Agreement/Enterprise Agreement Subscription customers who: Are not licensed for office Professional Plus, CAL and windows 10 suits and want to license it as cloud services on per user license basis. want to license net new users for the Enterprise Platform as cloud services on per user basis. Orderable at Mid-term, Renewal or Anniversary. Microsoft 365 Add-On  This one is only applicable to existing Enterprise Agreement/Enterprise Agreement Subscription customers who fall under one of the below cases Those who are currently paying

JSON Formatting in Modern SharePoint lists/libraries.

Image
One of the most important feature in modern SharePoint lists and library is its ability to be customized by JSON formatting. There are two different methods to do so. 1. additionalRowClass 2. rowFormatter Below is the one liner defs for both these methods. additionalRowClass is used when you only wnat to concentrate on one column in the list or library. rowFormatter is used to customize the complete Row. And if you decide to act smart and use both of them together, any styling applied to additionalRowClass will be lost. Now we will use rowFormatter, and for it we will create elements using DIVs we will create a Main DIV and nest 3 DIVs inside it. Below is the complete JSON for it. We have also applied styling to the DIVs. {   "$schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json",   "hideSelection": true,   "hideColumnHeader": true,   "rowFormatter": {     "elmType": "div",     "