cancel
Showing results for 
Search instead for 
Did you mean: 
sergeluca

Using the Azure Logic Apps Workflow Definition Language (WDL) in Microsoft Flow

 

 

Author : Serge Luca

Office Servers and Services MVP, Belgium

www.shareql.com

@sergeluca

 

 

There are many situations with Microsoft Flow where we need non standard features, and as developer  I am way too often tempted to jump on the custom api and to create my custom Azure function or Azure Web API to provide exactly what I need. If all you have is a hammer everything will look like a nail…

 

Using the hammer can be overkilled so let’s add another tool to our (Flow) toolbox.

 

In some cases using the Azure Logic Apps Workflow Definition Language (WDL) directly  can be convenient. This WDL is actually part of Logic Apps, the workflow engine running behind Microsoft Flow.

 

This WDL is used behind any Flow and it shows-up in the Flow Designer.

 

Let’s take 4 examples.

 

Example 1  (the easy one)

 

I have a SharePoint list with a custom column named "Amount". The flow is triggered when a new item is added into the list and I want to check its value. This is straightforward in Flow :

 

flowcondition1

 

If we click the “option “Edit in advanced mode” we will see the Logic Apps WDL expression.

 

flowcondition2

 

To find more information regarding the Logic Apps WDL, go to the following site :

 

wdl

 

A flow is actually composed of a set of JSON objects and the associated value pairs are available from the WDL.

 

Example 2

 

A Flow is triggered when a new item is added in a SharePoint list. The SharePoint list has a “ID” system column which is unique. Each row is a contract and the contract ID must be unique. The contractID is automatically generated when the item is added in the list.

The logic is : CONTRACT-XXXX where XXXX is the list idem ID minus 10 and formatted on 4 letters.

 

ex if ID is 50, the contract ID must be CONTRACT-0040.

 

To generate the contract, we need to rely on the Compose action.

The workflow will look like this :

 

flowcontract

 

The second action is the Compose action with the following value :

 

compose

 

The WFDL code will look like this :

 

compose2

 

“@concat(‘CONTRACT-‘,substring(string(add(sub(float(triggerbody()?[‘ID’]),10),10000)),1,4))”

 

If the SharePoint ID is 51

  • ?[‘ID’])  will return 51  (as a string) ; triggerBody returns the JSON object containing the trigger action.
  • float(triggerbody()?[‘ID’]) will return 51 (as a float)
  • sub(float(triggerbody()?[‘ID’]),10)  will remove 10 from 51-> 41
  • add(sub(float(triggerbody()?[‘ID’]),10),10000)  will add 10000 ->10041
  • substring(string(add(sub(float(triggerbody()?[‘ID’]),10),10000)),1,4) ->0041

 

In order to dig a little bit I’ve checked the content of triggerbody() by adding a Compose action (by the way don’t forget the double quotes before and after the expression)

 

triggerbodyInternal

 

What we get is this (a nice JSON result) :

 

returntriggerbodyInternal

 

I also noticed after running the flow, that my custom code became a Body variable (the body variable was not available before) :

 

bodyvariable

 

For the record  trigger-body() is a shorcut for trigger().outputs.body

 

 

Example 3.  

 

Let’s take a look at the Flow template

 

blopost10daystemplate

 

The logic of this template is that if the last blog post has been posted more than days days ago you will get a reminder. Here the condition must be expressed in WDL : (the basic mode doesn’t work at all)

 

bogpost10days

 

The WDL code is the following:

 

@less(string(first(body(‘List_all_RSS_feed_items’))[‘publishDate’]), addDays(utcnow(),-10))

 

body(‘List_all_RSS_feed_items’) : returns the raw content of what the action List all RSS feed items returns.

 

If we open a blog feed in a browser, for instance my own blog feed https://sergeluca.wordpress.com/feed/

we will see that the publication date is a field named

 

pubdate

 

However when we run the worklfow and check the value associated with a completed instance, we see this :

 

bodyblogshistory

 

Even tough the RSS is xml based, the RSS action has transformed it into JSON and the “Pubdate”  field has been renamed “PublishDate”

 

bodyblogs

 

So string(first(body(‘List_all_RSS_feed_items’))[‘publishDate’])  returns the publishing date of the first post (which is chronologically the last one)

 

@less(string(first(body(‘List_all_RSS_feed_items’))[‘publishDate’]), addDays(utcnow(),-10)) says if the last blog post has been published before today minus 10 days then a reminder needs to be sent.

 

So the rule is:

  • if you want to analyse an action output, use body()
  • if you want to analyse an trigger output, use trigger_body()  

Don’t forget to add the WDL site to you favorites.

 

 

Example 4. You want to check if a query to a SharePoint list is empty

 

The key thing is that  the list of all the items returned from Get item is stored in a vriable called ‘value’.

 

-> if you switch the Condition action in “advacned” mode, you can type the expression:  “@empty(body(‘Get items’)[‘value’])

 

emptysharepointlist

 

Another (less efficient) option would be:  @equals(length(body(‘Get Items’)?[‘value’]),0)

 

Have fun !

 

Author : Serge Luca

Office Servers and Services MVP, Belgium

www.shareql.com

@sergeluca

 

Comments

Hi Serge,

 

I guess not, but would it be possible to strip out all html tags from a given string of text?

 

Bart

Thanks for the great post.

 

Are you aware of an elegant way to look for a value in a JSON array?

 

This is the data that "ActionOutputs('HTTPAction')?['Body']" returns:

 

{

  "RequestedType": "PeopleList"

  "People":[

   {

      "Name": "Mike",

      "Surname":"Bike"

     },

     {

      "Name":"Joe",

      "Surname":"Doe"

    }

   ]

 }

 

If I use "ActionOutputs('HTTPAction')?['Body']?['People'][1]['Surname']" it will return Joe Doe's surname, but what if I don't know which number of the array holds the value that I am looking for? If there a way to look for Joe's name and then return his Surname using WDL, or do I have to use Flow to parse and then for each to loop through the data?

About the Author
  • Experienced Consultant with a demonstrated history of working in the information technology and services industry. Skilled in Office 365, Azure, SharePoint Online, PowerShell, Nintex, K2, SharePoint Designer workflow automation, PowerApps, Microsoft Flow, PowerShell, Active Directory, Operating Systems, Networking, and JavaScript. Strong consulting professional with a Bachelor of Engineering (B.E.) focused in Information Technology from Mumbai University.
  • I am a Microsoft Business Applications MVP and a Senior Manager at EY. I am a technology enthusiast and problem solver. I work/speak/blog/Vlog on Microsoft technology, including Office 365, Power Apps, Power Automate, SharePoint, and Teams Etc. I am helping global clients on Power Platform adoption and empowering them with Power Platform possibilities, capabilities, and easiness. I am a leader of the Houston Power Platform User Group and Power Automate community superuser. I love traveling , exploring new places, and meeting people from different cultures.
  • Read more about me and my achievements at: https://ganeshsanapblogs.wordpress.com/about MCT | SharePoint, Microsoft 365 and Power Platform Consultant | Contributor on SharePoint StackExchange, MSFT Techcommunity
  • Encodian Owner / Founder - Ex Microsoft Consulting Services - Architect / Developer - 20 years in SharePoint - PowerPlatform Fan
  • Founder of SKILLFUL SARDINE, a company focused on productivity and the Power Platform. You can find me on LinkedIn: https://linkedin.com/in/manueltgomes and twitter http://twitter.com/manueltgomes. I also write at https://www.manueltgomes.com, so if you want some Power Automate, SharePoint or Power Apps content I'm your guy 🙂
  • I am the Owner/Principal Architect at Don't Pa..Panic Consulting. I've been working in the information technology industry for over 30 years, and have played key roles in several enterprise SharePoint architectural design review, Intranet deployment, application development, and migration projects. I've been a Microsoft Most Valuable Professional (MVP) 15 consecutive years and am also a Microsoft Certified SharePoint Masters (MCSM) since 2013.
  • Big fan of Power Platform technologies and implemented many solutions.
  • Passionate #Programmer #SharePoint #SPFx #M365 #Power Platform| Microsoft MVP | SharePoint StackOverflow, Github, PnP contributor
  • Web site – https://kamdaryash.wordpress.com Youtube channel - https://www.youtube.com/channel/UCM149rFkLNgerSvgDVeYTZQ/