Snippets

Code I keep coming back to

Short, tested pieces of AL, X++, Power Fx and PowerShell, each one solving a single problem on a real project. Copy it, change the names, move on. The reasoning behind them lives in the writing.

3 snippets

3 languages

01Library

Plain text

1 of 3

Filter Dataverse rows to the last seven days
Plain text
An OData filter expression for the List rows action that pushes the date window onto the server.
Plain text
```
statuscode eq 1 and createdon gt @{addDays(utcNow(), -7)}
```
Note
Put this in Filter rows, not in a Condition inside Apply to each. Filtering in the flow means every row still crossed the wire.
- Power Automate
- Dataverse
- OData

Code I keep coming back to

Plain text

Filter Dataverse rows to the last seven days