Tag Archives: Power Automate

Track specific column update of SharePoint List Item when using Power Automate Cloud Flows

Coming from a Dynamics CRM/ Dataverse background and having written plugins and later flows using Common Data Service (Current Environment) connector, I was a little lost looking at the SharePoint trigger for When a list item is added or modified. With the CDS (CE) connector, when you use the When an item is created, updated,… Read More »

How to Find Next Month and Previous Month using Power Automate within Dynamics 365 CRM

Introduction In this blog, we are checking how we can calculate the next/previous month’s date time from today’s date time or calculate the next/previous month’s date time from the selected date. There is no direct way or predefined function to calculate the next/previous month in Power Automate. However, we can achieve this process using the… Read More »

Locational Intelligence Simplified: Unpacking latest enhancements in Maps integration within Dynamics 365 CRM/Power Apps December 2020 release!

“Perfection is not attainable, but if we chase perfection, we can catch excellence.”On that note, it’s time to welcome another step towards excellence with the latest Maplytics December 2020 release! In this webinar, we will navigate the latest enhancements made to the most popular features of Maplytics – Auto Scheduling, Territory Management, PCF controls, and… Read More »

How to set Owner field dynamically using Power Automate CDS Connector (Current Environment)

Introduction In our last blog, we saw How to set or map null value in Lookup Field using Power Automate CDS Connector. In this blog, we will explore How to set the Owner field dynamically using Power Automate. Scenario: On the Contact entity, there is an owner field and we want to set the same… Read More »

Use Relevance Search API in Power Automate & Canvas App – Part 2

Introduction In the previous blog, we obtained the response from the Relevance Search API request through Power Automate Flow. In this blog, we will use that response in the Canvas app. We will see how we can leverage the potential of Relevance search in the Canvas app. If you are not familiar with how to… Read More »

Use Relevance Search API in Power Automate & Canvas App – Part 1

Introduction Relevance Search has been there for a while in our Dynamics 365 CRM that provides access to exciting new search capabilities in the environment. However, before you use this feature, an administrator must enable relevance search in target environment. Using relevance search we can search across multiple tables/entities, sorted by relevance. Let us say… Read More »

Converting DateTime field in a different format in Power Automate using formatDateTime function

Introduction In this blog, we can see how we can convert DateTime type field to the various format using formatDateTime function. Please find the syntax of formatDateTime function: formatDateTime(DATE_TIME_VALUE,DATE_TIME_STRING_FORMAT) Scenario: One of our clients wanted to see the last modified date and time of individual Account record. Also, he wants to see this modified date… Read More »

Formatting Output result for your actions in Custom Connector

Continuing with the series on Custom Connector, today I touch upon output results of your actions. If you have worked with any of the existing connectors including Common Data Service connectors, you will notice that when you choose an action like List or Read, the CRM record object returns individual field values of the record… Read More »

How to set or map null value in Lookup Field using Power Automate CDS Connector (Current Environment)

Introduction Power Automate is a powerful business application that allows the user to create and automate workflows across multiple applications and services without developers’ help. In this blog, we will explore how to set a lookup field as null while mapping the Lookup field with another record’s lookup field which has null value. We can… Read More »