Understanding the PowerApps Add Picture control
October 10, 2017
Canviz Lights Up Microsoft Ignite Sessions
October 11, 2017

Here’s a little function you can use to ensure your PowerApps follow basic English language grammar rules for the words A and AN.

This function displays the words A and AN appropriately, based on the word that comes after them in a sentence.

If(IsMatch(<TEXT TO EVALUATE>, "[AEIOUaeiou]", BeginsWith), "an ", "a ")

Note: This function does not take into account special cases like the words university and honor, but you could easily adapt the logic to handle additional words.

The following screenshots show it in action.