Category Archives: JavaScript

Custom Forms in Classic SharePoint and Power Automate DLP Heads Up

Interactive Business Systems is now Planet Technology. Looking for a new job? We work with some of the biggest names in tech, and we’re hiring! Check out our open jobs and make your next career move with Planet.


On April 25th, 2020 we received message center notification MC210713 in our tenant indicating there was going to be a feature deprecation in SharePoint Designer impacting custom form creation.  If your organization has completely adopted the modern SharePoint experience this notification will not impact you in anyway. On April 23rd, 2020 we received message center notification MC210568 indicating there were updates to Power Platform Data Loss Prevention capabilities.  This update removes the “data governance blocker” for organizations that have yet to enable Power Automate nee Flow and Power Apps within their environment.  Ironically the latter announcement indicated the starting date of the Data Loss Prevention capability updates was April 22nd, 2020…nice timing there Microsoft😊. Feel free to read on to understand how the two are related, especially if your still using Classic SharePoint sites with customizations in your environment! Read more

Javascript Copy to Clipboard for Excel

Interactive Business Systems is now Planet Technology. Looking for a new job? We work with some of the biggest names in tech, and we’re hiring! Check out our open jobs and make your next career move with Planet.

I recently had a requirement to “export” data shown in a table on a web page to an Excel file.  In a normal situation I’d do something server-side to generate an Excel file with the necessary data, but unfortunately this situation was not a normal. The project I was working on did not have a server-side component – it was completely client-side code – so I couldn’t just create an Excel file.  The solution I came up with was to provide a way for the users to copy the required data to their clipboard and they could then paste it into an Excel document. Read more

Form Validation and Custom Save Functionality in the Standard SharePoint List Form

Interactive Business Systems is now Planet Technology. Looking for a new job? We work with some of the biggest names in tech, and we’re hiring! Check out our open jobs and make your next career move with Planet.


I have a client that needs to log any interactions with their customers in SharePoint.  This client is proficient enough with SharePoint that they feel perfectly comfortable modifying lists in order to add or remove fields to accommodate their needs without having to go through us.  They are regularly adding new fields to this log list in order to capture some new piece of relevant information that it was decided they needed.  This is important background because when they approached me to create a way for them to generate multiple log entries from one “New Item” SharePoint List Form, I knew I couldn’t just create a custom “New Item” form to accomplish this or they would lose the ability to add new fields without having to either modify this custom “New Item” form, or involve us to make those modifications.

So I had to come up with a solution that would retain the standard “New Item” form (so any fields added/removed from the list would be reflected in the form) but would allow for the user to create an entry in their logs for every customer selected in the form.

Read more

« Older Entries