Dyota's blog

Translation sheet

Arrays

Array access, first element

JavaScript 
someArray[0]
PowerShell 
$someArray[0]
Power Query 
someList{0}
Power Apps 
Index(someTable, 1)
Azure Workflow Definition Language 
someArray[0]

Skip the first element

JavaScript 
someArray.slice(1)
PowerShell 
$someArray | Select-Object -Skip 1

Check if array of string contains a string element 'thisString'

JavaScript 
someArray.contains('thisString')
PowerShell 
$someArray -contains 'thisString' # not case sensitive
$someArray -ccontains 'thisString' # case sensitive
$someArray.Contains('thisString') # case sensitive
Power Query 
List.Contains(someList, "thisString")
Power Apps 
CountRows(Filter(someTable, Value = "thisString")) > 0
Azure Workflow Definition Language 
contains(someArray, 'thisString')

Basic for loop

JavaScript 
for (var i = 0; i < array.length; i++) {}
PowerShell 
for ($i = 0; $i -lt $array.Count; $i++) {}

Map a over array, return modified array

JavaScript 
array.map((e) => { return e })
Power Query 
List.Transform(list, each _ )
PowerShell 
$array | ForEach-Object { $_ }
$array | % { $_ }
$array.ForEach({ $_ })

Generate sequence from 2 to 9

JavaScript 
(function sequence(start, end) { return Array.from({length: (end - start + 1)}, (_, i) => i + start) })(2, 9)
PowerShell 
@(2..9)
Power Query 
{2..9}
Power Apps 
Sequence(8, 2, 1)

Combine multiple arrays into one array

JavaScript 
[].concat.apply([], arrayOfArrays ));
PowerShell 
arrayOfArrays
Power Query 
List.Combine(listOfLists)

Objects

Loop over all object properties

PowerShell 
$object.PSObject.Properties | ForEach-Object { $_.Name $_.Value}

Strings

Check if string contains substring

PowerShell 
$a.Contains($b) # case sensitive
Power Query 
Text.Contains(a, b)

Replace substring b in text a with c

PowerShell 
$a -replace '$b', '$c' # not case sensitive
$a -creplace '$b', '$c' # case sensitive
$a.Replace('$b', '$c') # case sensitive
Power Apps 
Substitute(a, b, c)
Power Query 
Text.Replace(a, b, c)

Extract substring from nth character onward [for m characters]

JavaScript 
a.slice(n [, n+m])
PowerShell 
$a.Substring(n [, m])
Power Query 
Text.Middle(a, n [, m])

Types

Check if variable is a string

PowerShell 
$a -is [string]
$a.GetType().Name -eq 'String'

#azurewdl #javascript #powerapps #powerautomate #powerquery #powershell