Your Power Fx Formula
Enter a Power Fx formula and click Check Delegation to analyze
| Function/Operator | Dataverse | SharePoint | SQL Server | Excel |
|---|---|---|---|---|
| Filter | ✓ Yes | ✓ Yes | ✓ Yes | ✗ No |
| Sort / SortByColumns | ✓ Yes | ✓ Yes | ✓ Yes | ✗ No |
| Search | ✓ Yes | ✗ No | ✓ Yes | ✗ No |
| LookUp | ✓ Yes | ✓ Yes | ✓ Yes | ✗ No |
| = (equals) | ✓ Yes | ✓ Yes | ✓ Yes | ✗ No |
| <>, >, <, >=, <= | ✓ Yes | ✓ Yes | ✓ Yes | ✗ No |
| StartsWith | ✓ Yes | ✓ Yes | ✓ Yes | ✗ No |
| EndsWith | ✗ No | ✗ No | ✗ No | ✗ No |
| in (contains) | ✗ No | ✗ No | ✗ No | ✗ No |
| And (&&) | ✓ Yes | ✓ Yes | ✓ Yes | ✗ No |
| Or (||) | ✓ Yes | ✗ No | ✓ Yes | ✗ No |
| Not (!) | ✓ Yes | ✗ No | ✓ Yes | ✗ No |
| Sum / Average / Min / Max | ✗ No | ✗ No | ✗ No | ✗ No |
| CountRows | ✗ No | ✗ No | ✗ No | ✗ No |