Build apps. Automate work. Analyze everything. Master the Power Platform.

// Common date expressions
utcNow()                              // current UTC timestamp
addDays(utcNow(), 7, 'yyyy-MM-dd')    // +7 days, formatted
convertTimeZone(utcNow(), 'UTC',
  'India Standard Time', 'dd-MMM hh:mm tt')
formatDateTime(addHours(
  triggerBody()?['CreatedOn'], 2), 'g')

// Safe navigation + fallback with coalesce
coalesce(
  triggerBody()?['Approver']?['DisplayName'],
  'No approver assigned')

// Inline if — approve anything under $5k
if(lessOrEquals(
     float(outputs('Get_Invoice')?['body/Amount']),
     5000),
   'Auto-Approved', 'Needs Manager')

// Distinct values without Apply-to-each
union(
  body('Select_Departments'),
  body('Select_Departments'))

// Join names with comma for an email body
join(body('Select_Names'), ', ')

// First item / count helpers
first(body('Filter_array'))
length(outputs('Get_items')?['body/value'])

// SharePoint "Get items" → Filter Query field
Status eq 'Pending' and Amount gt 1000
substringof('urgent', Title)
Created ge @{addDays(utcNow(),-30,'yyyy-MM-dd')}

// Dataverse "List rows" → Filter rows
statecode eq 0 and prioritycode eq 1
createdon ge @{formatDateTime(
  addDays(utcNow(),-7),'yyyy-MM-dd')}

Total Sales = SUM ( Sales[Amount] )

Sales YTD =
CALCULATE ( [Total Sales],
    DATESYTD ( 'Date'[Date] ) )

Sales vs LY % =
VAR LY = CALCULATE ( [Total Sales],
    SAMEPERIODLASTYEAR ( 'Date'[Date] ) )
RETURN
DIVIDE ( [Total Sales] - LY, LY )

Product Rank =
RANKX (
    ALLSELECTED ( 'Product'[Name] ),
    [Total Sales], , DESC, Dense
)

Running Total =
CALCULATE (
    [Total Sales],
    FILTER (
        ALL ( 'Date'[Date] ),
        'Date'[Date] <= MAX ( 'Date'[Date] )
    )
)

let
  Source = Csv.Document(File.Contents("C:\data\orders.csv"),
             [Delimiter=",", Encoding=65001]),
  Promoted = Table.PromoteHeaders(Source),
  Typed = Table.TransformColumnTypes(Promoted,
    {{"Amount", Currency.Type},
     {"OrderDate", type date}}),
  Clean = Table.SelectRows(Typed,
    each [Amount] <> null and [Amount] > 0)
in
  Clean

let
  Source = Excel.CurrentWorkbook()
             {[Name="SalesTable"]}[Content],
  WithMargin = Table.AddColumn(Source, "Margin",
    each [Revenue] - [Cost], type number),
  Unpivoted = Table.UnpivotOtherColumns(
    WithMargin, {"Region"},
    "Measure", "Value")
in
  Unpivoted

// Create a record (model-driven form / PCF)
const account = { name: "Contoso Ltd",
  revenue: 1500000 };
await Xrm.WebApi.createRecord("account", account);

// Query with OData
const res = await Xrm.WebApi.retrieveMultipleRecords(
  "account",
  "?$select=name,revenue" +
  "&$filter=revenue gt 100000" +
  "&$orderby=revenue desc&$top=5");

function onIndustryChange(executionContext) {
  const form = executionContext.getFormContext();
  const industry =
    form.getAttribute("industrycode").getValue();

  if (industry === 1) { // Accounting
    form.getControl("creditlimit")
        .setNotification("Requires CFO approval", "warn1");
  } else {
    form.getControl("creditlimit")
        .clearNotification("warn1");
  }
}

GET https://org.crm.dynamics.com/api/data/v9.2/
    accounts?$select=name&$top=3
Authorization: Bearer eyJ0eXAiOi...
OData-MaxVersion: 4.0
Prefer: odata.maxpagesize=50

PATCH .../api/data/v9.2/accounts(<guid>)
Content-Type: application/json
{ "telephone1": "555-0199",
  "description": "Updated via Web API" }

{% fetchxml openTickets %}
<fetch top="5">
  <entity name="incident">
    <attribute name="title" />
    <filter><condition attribute="statecode"
      operator="eq" value="0" /></filter>
  </entity>
</fetch>
{% endfetchxml %}

{% for case in openTickets.results.entities %}
  <li>{{ case.title | escape }}</li>
{% endfor %}