TL;DR: Auto-switch to a test email in Power Apps Studio and the real User().Email in production via StartsWith(Host.Version, "PowerApps-Studio").

💡 Challenge

While developing apps in Power Apps Studio, you often want to use test values, like a test email address, without risking that they end up in production.

✅ Solution

Check whether the app is running in Studio mode. If it is, use a test email for development; in production the app automatically switches to the real user’s email address.

🔧 How It’s Done

Use this formula to detect Studio mode and switch email addresses accordingly:

fxIsStudioMode = StartsWith(Host.Version, "PowerApps-Studio");
fxUserEmail = If(
    fxIsStudioMode,
    "testaccount@company.com",
    User().Email
);

🔸 Place these in the App.OnStart property so the variables are set when the app initializes.

🔸 You get the test email during development and the correct user email in production, with no manual changes.

🎉 Result

No more accidentally shipping apps with hardcoded test emails, the switch is seamless and automatic.

🌟 Key Advantages

🔸 Prevents accidental deployment of test data

🔸 Saves time by automating email assignment

🔸 Enhances app security and consistency

Special thanks to Matthew Devaney for sharing this fantastic Power Apps tip!


🎥 Video Tutorial


🛠️ FAQ

1. How do I determine if my app is in Studio Mode? Use the StartsWith function on Host.Version to check for “PowerApps-Studio”.

2. Can I apply this pattern to other test values? Yes, use the same logic to switch between development and production values for any parameter.

3. Where should I place these formulas in my app? Put them in the App.OnStart property so the variables are set when the app initializes.

Marcel Lehmann

Marcel Lehmann

Microsoft MVP Microsoft MVP

BizzApps MVP from Switzerland 🇨🇭 - PowerPlatform Expert & Evangelist & MVP - Turning passion into expertise

MVP since 2023 Power Platform Expert since 2017