Author Archives

I am a tech enthusiast with a passion to solve real world problems with the help of technology and automation

• Perform CRUD operations on expanding datasets in SharePoint (Part 2)

  By Kaushal Kodagoda on January 16, 2022 • ( 0 )

  This post is a part of an ongoing series. If you are new to this topic, I highly recommend going through my previous posts: How to use SharePoint lists to store expanding datasets 2. Perform CRUD operations on expanding datasets… Read More ›

• Perform CRUD operations on expanding datasets in SharePoint (Part 1)

  By Kaushal Kodagoda on January 16, 2022 • ( 0 )

  This post is a part of a series. If you are new to this use case, please check my previous post to understand the problem and solution design. In this post, we will discuss how to perform CRUD operations on… Read More ›

• Using SharePoint list for expanding datasets

  By Kaushal Kodagoda on January 15, 2022 • ( 3 )

  Recently one of my clients asked to create an app to store daily time entries for their users. Dataverse was not an option as their requirement was to create this dataset in SharePoint. Below is the use case and technical… Read More ›

• Transpose table columns using Power Automate (With example)

  By Kaushal Kodagoda on August 29, 2021 • ( 5 )

  Power automate always works with defined column headers. Let’s take an example. Contoso uses a permission matrix to determine access provisioning based on employee role. Role Office365 Outlook Adobe License D365 Sales D365 Marketing Office Admin Yes Yes Sales Rep… Read More ›

• Prevent orphan flows by automatically assigning admin account as co-owner

  By Kaushal Kodagoda on July 17, 2021 • ( 1 )

  Imagine a scenario where you have to make changes to a personal cloud flow that was not shared with anyone. If the user who created the flow leaves the organization, no one would be able to see the flow unless… Read More ›

• Fixing Dynamics 365 Marketing Event Portal Loading Issues

  By Kaushal Kodagoda on April 2, 2021 • ( 0 )

  I recently updated Dynamics 365 Marketing instance and installed the portal application. Here are the steps I followed to deploy the sample event portal: Power Apps portal hosted custom event website (Dynamics 365 Marketing Developer Guide) | Microsoft Docs I… Read More ›

• Dynamics 365 Customer Service macros – Update case field values

  By Kaushal Kodagoda on February 14, 2021 • ( 1 )

  

  This is the second post of this series, if you are not familiar with the Agent scripts and Macros, you can check out the previous article for a step by step tutorial on how to configure Macros and Agent Scripts…. Read More ›

• Dynamics 365 Customer Service macros – Create new case with predefined field values

  By Kaushal Kodagoda on February 14, 2021 • ( 3 )

  

  Dynamics365 is adding more and more features to help automate repetitive tasks for users in Customer Support product space. One of the latest additions is Agent Scripts and Macros in CS space. Macro function has lots of options available however… Read More ›

• How to copy planner tasks with labels using Graph API

  By Kaushal Kodagoda on February 5, 2021 • ( 0 )

  I tried to create a flow that copies planner tasks from one plan to another and came across an issue where standard flow connectors did not support copying labels. I found that this could be implemented using graph API. Here… Read More ›

• Update current time and current user without using Javascript in model driven forms

  By Kaushal Kodagoda on December 14, 2020 • ( 0 )

  

  Sometimes we need to capture field updates for audit purposes. Here is an example: Account form has a field for “Account Application Status” (Options – Approved/Rejected). In either case, we need to capture who approved/rejected the application and date/time. My… Read More ›