Friday Functions Series | Coalesce Function to Handle Null Values

@ArtsyPowerApper shows how to protect your Flows from missing or null values which are needed for your actions. Fill in the blanks with the Coalesce Expression. Also learn how to handle dynamic content within an Apply to Each block for advanced expressions. Finally bring it all together in a fashion that won't display any errors!

P.S. I made this a little extra hard in the apply to each block, but don't hesitate to use Coalesce with simple dynamic content, or even plain text or numbers, too! In this case I could have gotten all of the peak codes from the select block, so they would have looked the same and worked better.

Coalesce and other functions for managing null values:
https://docs.microsoft.com/en-us/powe...