Part 2 of 5: Power Automate Expressions — Use coalesce, empty and if Safely

Power Automate Engineering — Part 2 of 5. Power Automate expressions help normalize optional data and avoid failures caused by null values. The right expression depends on whether a value is missing, empty or a specific type.

What you will learn

Use coalesce to select the first non-null value, empty to test whether a collection or string has no content, and if to choose a result based on a Boolean condition. For example: coalesce(triggerBody()?[’emailaddress1′], ‘unknown@example.invalid’) supplies a fallback when the field is null.

Implementation approach

Begin with a small, testable scope. Record the requirement, identify the Dataverse or platform component involved, and make the change in a development environment. Use solution-aware components and keep environment-specific values outside the implementation. Review the result with a second developer before promoting it.

Practical example

// Example development checklist
// 1. Confirm the requirement and owning component
// 2. Implement in a development environment
// 3. Validate permissions, null values and failure paths
// 4. Record configuration and dependencies
// 5. Promote through a controlled test deployment

Common mistakes to avoid

Do not confuse null with an empty string or an empty array. Avoid using placeholder values that could be mistaken for real customer data.

Testing checklist

Test null, empty, valid and unexpected values using manual test runs. Inspect the evaluated expression outputs in run history.

Power Automate Engineering: All 5 Parts

Continue with the next part in this series to build on these concepts. Validate each step in a non-production environment before applying it to a live workload.