Perform CRUD operations on expanding datasets in SharePoint (Part 2)
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 in SharePoint (Part 1) So far, we have created an expandable dataset in SharePoint and…
Perform CRUD operations on expanding datasets in SharePoint (Part 1)
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 this dataset. Let’s start.. Here’s our dataset record sample: How to READ this data inside…
Using SharePoint list for expanding datasets
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 challenges: For all users, they needed to update daily values for 2 weeks : 14…
Transpose table columns using Power Automate (With example)
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. RoleOffice365 Outlook Adobe LicenseD365 SalesD365 MarketingOffice AdminYesYesSales RepYesYesSales ManagerYesYesYesCTOYesYesYes HR manager wants to create role based permissions checklist for new employees. We need to get all columns that have “Yes”…
Prevent orphan flows by automatically assigning admin account as co-owner
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 they go to flow admin section and look for the orphan flow. Once you find…
Fixing Dynamics 365 Marketing Event Portal Loading Issues
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 downloaded event portal zip file according to the application version and deployed it using DeployToDynamics365Instance.ps1…
Dynamics 365 Customer Service macros – Update case field values
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. Since we have already discussed the background in the previous post, let’s dive right into…
Dynamics 365 Customer Service macros – Create new case with predefined field values
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 in this article, I am only focusing on Case related actions. Before we begin, here…
How to copy planner tasks with labels using Graph API
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 are the steps: Prerequisites Create an app registration in Azure AD Follow the steps mentioned…
Update current time and current user without using Javascript in model driven forms
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 first idea was to implement this using business rules. However, this cannot be implemented using…
immersivecoder 