Blog Post

Azure Integration Services Blog
3 MIN READ

Data Mapper Patterns

KentWeareMSFT's avatar
KentWeareMSFT
Icon for Microsoft rankMicrosoft
Jul 06, 2023

In this post, we will consolidate Data Mapper Patterns for the new data transformation tool available in Azure Logic Apps. New to the Data Mapper? Please see our Public Preview announcement post.

 

Title & LinkCategoryAuthorPublished Date
Direct Access, IndexCollectionParth Shah5/1/2025
Min, Max, AverageCollectionParth Shah4/10/2025
Sum AggregateCollectionParth Shah4/4/2025
Conditional MappingLogical comparisonKent Weare5/1/2023
Regular ExpressionsStringKent Weare6/12/2023
AggregationGeneralSandro Pereira7/6/2023
String Functions VideoStringSandro Pereira7/12/2023
Code points to stringStringSandro Pereira7/10/2023
ConcatStringSandro Pereira7/10/2023
ContainsStringSandro Pereira7/10/2023
Ends withStringSandro Pereira7/10/2023
LengthStringSandro Pereira7/10/2023
LowercaseStringSandro Pereira7/10/2023
Name (Name Value Pairs)StringSandro Pereira7/10/2023
ReplaceStringSandro Pereira7/10/2023
Starts withStringSandro Pereira7/10/2023
String to codepointsStringSandro Pereira7/10/2023
SubstringStringSandro Pereira7/10/2023
Substring afterStringSandro Pereira7/10/2023
Substring beforeStringSandro Pereira7/10/2023
TrimStringSandro Pereira7/10/2023
Trim leftStringSandro Pereira7/10/2023
Trim rightStringSandro Pereira7/10/2023
UppercaseStringSandro Pereira7/10/2023
ConversionConversionSandro Pereira8/3/2023
Add DaysDate and TimeSandro Pereira8/3/2023
Add DayTime to DateDate and TimeSandro Pereira8/3/2023
Add DayTime to DateTimeDate and TimeSandro Pereira8/3/2023
Add DayTime to TimeDate and TimeSandro Pereira8/3/2023
Add YearMonth to DateTimeDate and TimeSandro Pereira8/3/2023
Adjust DateDate and TimeSandro Pereira8/3/2023
Current DateDate and TimeSandro Pereira8/3/2023
Current DateTimeDate and TimeSandro Pereira8/3/2023
Current TimeDate and TimeSandro Pereira8/3/2023
DateTimeDate and TimeSandro Pereira8/2/2023
Day from DateDate and TimeSandro Pereira8/2/2023
Day from DateTimeDate and TimeSandro Pereira8/2/2023
Equal DateDate and TimeSandro Pereira8/2/2023
Equal DateTimeDate and TimeSandro Pereira8/2/2023
Equal DayDate and TimeSandro Pereira8/2/2023
Equal MonthDate and TimeSandro Pereira8/2/2023
Equal MonthDayDate and TimeSandro Pereira8/2/2023
Equal TimeDate and TimeSandro Pereira8/2/2023
Equal YearDate and TimeSandro Pereira8/2/2023
Equal YearMonthDate and TimeSandro Pereira8/2/2023
Greater DateDate and TimeSandro Pereira8/3/2023
Greater DateTimeDate and TimeSandro Pereira8/3/2023
Greater TimeDate and TimeSandro Pereira8/3/2023
Hours from DateTimeDate and TimeSandro Pereira8/3/2023
Hours from TimeDate and TimeSandro Pereira8/3/2023
Less DateDate and TimeSandro Pereira8/3/2023
Less DateTimeDate and TimeSandro Pereira8/3/2023
Less TimeDate and TimeSandro Pereira8/3/2023
Minutes from DateTimeDate and TimeSandro Pereira8/3/2023
Minutes from TimeDate and TimeSandro Pereira8/3/2023
Month from DateDate and TimeSandro Pereira8/3/2023
Month from DateTimeDate and TimeSandro Pereira8/3/2023
Seconds from DateTimeDate and TimeSandro Pereira8/4/2023
Seconds from TimeDate and TimeSandro Pereira8/4/2023
Subtract DatesDate and TimeSandro Pereira8/4/2023
Subtract DateTimesDate and TimeSandro Pereira8/4/2023
Subtract DateTime from DateDate and TimeSandro Pereira8/4/2023
Subtract DateTime from TimeDate and TimeSandro Pereira8/4/2023
Subtract TimesDate and TimeSandro Pereira8/4/2023
Subtract YearMonth from DateDate and TimeSandro Pereira8/4/2023
Subtract YearMonth from DateTimeDate and TimeSandro Pereira8/4/2023
Time zone from DateDate and TimeSandro Pereira8/7/2023
Time zone from DateTimeDate and TimeSandro Pereira8/7/2023
Time zone from TimeDate and TimeSandro Pereira8/7/2023
Year from DateDate and TimeSandro Pereira8/7/2023
Year from DateTimeDate and TimeSandro Pereira8/7/2023
CopyUtilitySandro Pereira8/8/2023
ErrorUtilitySandro Pereira8/8/2023
Format dateUtilitySandro Pereira8/8/2023
Format DateTimeUtilitySandro Pereira8/8/2023
Format NumberUtilitySandro Pereira8/8/2023
Format TimeUtilitySandro Pereira8/8/2023
Distinct ValuesCollectionKent Weare8/9/2023
AbsoluteMathSandro Pereira8/9/2023
AddMathSandro Pereira8/9/2023
ArctangentMathSandro Pereira8/9/2023
CeilingMathSandro Pereira8/9/2023
CosineMathSandro Pereira8/9/2023
DivideMathSandro Pereira8/9/2023
ExponentialMathSandro Pereira8/9/2023
Exponential (base 10)MathSandro Pereira8/9/2023
FloorMathSandro Pereira8/9/2023
Integer divideMathSandro Pereira8/9/2023
LogMathSandro Pereira8/10/2023
Log (base 10)MathSandro Pereira8/10/2023
ModuloMathSandro Pereira8/10/2023
MultiplyMathSandro Pereira8/10/2023
PowerMathSandro Pereira8/10/2023
RoundMathSandro Pereira8/10/2023
SineMathSandro Pereira8/10/2023
Square rootMathSandro Pereira8/10/2023
SubtractMathSandro Pereira8/10/2023
TangentMathSandro Pereira8/10/2023

 

Looking for a particular pattern or have a pattern to contribute? Please add a comment below.

Updated Jun 26, 2025
Version 13.0

2 Comments

  • TonyHendriksen's avatar
    TonyHendriksen
    Copper Contributor

    Hi Kent,(and Sandro),

    Thanks for the overview of the different Patterns/Functions.

    Can you let me know where I can find more (latest) information about the functions in the data mapper.

    Or on the code behind the lml files and how it can be adjusted directly from there?

    Things like the functions in the 'collection' like direct Access (used in combination with an index or specific value to lookup) same goes for the 'filter'. 

    It would be very help full to see this. 

    Thanks!

    Tony