Category: Microsoft Dynamics 365

In this post, we’ll see how we can perform aggregate function on data such as Sum or Count using PowerAutomate. Unlike LINQ in C# or SQL, it’s not very straight forward to do using PowerAutomate for which I thought of sharing the approach we had taken.

Recently, we got a requirement to calculate the sum of Quantity, after grouping the data on 5 columns NDISNumber, SupportDeliveredFrom, SupportNumber, ClaimType and CancellationReason in a custom entity Claim.

Below are the steps we followed to achieve the result:

Initialize 5 variables to hold unique values of each group-by column inside Apply to each action we are going to use further. Please see…

Hi All,

Welcome,
Today we will see how to limit the number of responses in Microsoft Forms aka Customer Voice.

We have a survey, and customer can fill and submit this survey.
But, Requirement is to allow only first 5 customer to reply not more than that.

So Before this brand new customer voice product, this feature was not available in Microsoft forms
But now, Microsoft has come up with really good options and helped many organization 🙂

Thank you Microsoft.

SSRS Reports have a placeholder property HTML – Interpret HTML tags as styles. That property allows you to use HTML tags while displaying report.

We have to face the problem when we want to display SharePoint`s RichText field content is SSRS Report. RichText field may contain some characters that are stored different in SharePoint DB and cannot be interpreted by SSRS as HTML (eg. :, &, {, <, >,  list elements, etc.)