If you need to add padding and limit it to a certain length in C# substring(concat(‘0000000’,variables(‘MyNumber’)),length(string(variables(‘MyNumber’))),7) Above code will limit it to seven characters length
A simple function to convert GMT standard time to ddMMyyyyHHmmss convertFromUtc(utcNow(),’GMT Standard Time’,’ddMMyyyyHHmmss’)
Below is a query to check if List Records in Dynamics 365 in Azure Logic App contains some data and is not null length(body(‘List_accounts’)?[‘value’])
If we are using List Records (To get a list of records from Dynamics 365) in Logic App, some times we need to check if list returned any value or if its null before we use index 0 or greater to use the value
As we know we can only get one entity back if we are using Get record connector to query Dynamics 365 in Logic App however if we use List records to get a number of records or filter it on the basis of ID we have an option to get records from multiple entities as long as […]
If you are working in Dynamics 365 then most probably you have used or at least have heard about logic apps.
In this example, we are going to use Liquid template to transform our JSON input. Let’s say we have a requirement where we get data in JSON format and we need to amend JSON before we could pass it to azure function, any custom app, template or a third party API and in that case […]
Let’s say we have a azure blob storage URL and we want to download contents of the file and store it somewhere, for example we could get a blob URL from a public or client environment and we want to copy/save contents on our own environment too.
Today we are going to create a Logic App to pass some sample JSON data, do some basic steps in it, call Azure function from Logic App, connect to Dynamics 365 in azure function, create or update records in Dynamics CRM with in azure function and then return some results back in Logic App and […]
Let’s say we have a logic app which gets some data in JSON and some of the data is in array