crmtipoftheday: Tip #1440: Relative dates in sample data

[Blog bot]

Источник: https://crmtipoftheday.com/1440/rela...in-sample-data
==============

We all enjoy flexing our Dataverse or Dynamics 365 skills from time to time. Many of us have meticulously crafted a demo instance from proverbial stone and blood. However, one of the challenges is keeping the data up-to-date. There’s nothing worse than displaying 20 tasks that are all overdue by four months. Fortunately, Dataverse offers a fantastic feature that allows us to modify data during import! Grab yourself a cuppa, blanket, comfortable horizontal surface and dive in: Add transformation mappings for import (Microsoft Dataverse) – Power Apps | Microsoft Learn.

Alternatively, you can simply use an Excel file with formulas while following the instructions: Import or export data from Microsoft Dataverse – Power Apps | Microsoft Learn. Boing!

For fancier, more modern transformations you may want to look into Importing using a connector and Power Query.

#"Added Two Weeks" = Table.ReplaceValue( #"Changed column type", each [Due Date], each DateTime.From([Due Date]) + #duration(14,0,0,0), Replacer.ReplaceValue, {"Due Date"})


Источник: https://crmtipoftheday.com/1440/rela...in-sample-data