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 … Continue reading PowerAutomate: Perform “Group By” operation on Data
Category: SharePoint
D365: Download SharePoint document, attach to Email using PowerAutomate and Azure Function
In this post, we had discussed how to upload document to SharePoint using PowerAutomate. Here, we'll discuss how to download that document and attach it to an email activity. We'll extend the same PowerAutomate we were using in the previous post and will also see how to execute HTTP Triggered Azure Function from PowerAutomate. So, … Continue reading D365: Download SharePoint document, attach to Email using PowerAutomate and Azure Function
D365: Generate Word Document using Content Control, save to SharePoint and convert to pdf using PowerAutomate
In this post, we'll see how we can generate word document using content controls and PowerAutomate. We'll save the generated document in appropriate folder in Sharepoint so that it shows up on the appropriate Lead record. Then, we'll convert the word document to pdf document and store at the same location. To proceed, let's create … Continue reading D365: Generate Word Document using Content Control, save to SharePoint and convert to pdf using PowerAutomate
D365: “Access denied. You do not have permission to perform this action or access this resource” while calling SharePoint API from plugin/custom workflow
Recently, we were working on calling SharePoint API from plugin. While getting the access token we received the following error: "Access denied. You do not have permission to perform this action or access this resource". To fix this issue, we gave appropriate permission to the Application we had created in SharePoint for Server to Server … Continue reading D365: “Access denied. You do not have permission to perform this action or access this resource” while calling SharePoint API from plugin/custom workflow
D365: Call SharePoint API from plugin/custom workflow C# – Part 2
In the previous post, we saw how to create an app in SharePoint and give necessary permission. In this post, we'll see how to use the app details in C# to connect to SharePoint API. We can use the below code to get the access token: private static string TENANT_ID; private static string CLIENT_ID; private … Continue reading D365: Call SharePoint API from plugin/custom workflow C# – Part 2
D365: Call SharePoint API from plugin/custom workflow C# – Part 1
In this series of post, we'll see how we can call SharePoint API from plugin or custom workflow using C# to retrieve number of documents uploaded to SharePoint for a particular record, albeit we can do any other operation connecting to SharePoint API. To use SharePoint API, we need to create an Application in SharePoint … Continue reading D365: Call SharePoint API from plugin/custom workflow C# – Part 1
Ajit Patra 