Environment Variables in Power Apps

After yesterday’s post about environment variables in Power Automate, today it is time to look environment variables Power Apps.

Environment Variables

As I showed in yesterday’s post for the SPSite variable I’m now going to create an environment variable in my solution for the SharePoint list as well.

Environment variables in Power Apps

In the past you would connect to a SharePoint list by selecting a SharePoint site and then select a SharePoint list. But this is not what we want. We want Dynamic list selection!

This is where the variables come in!

On the Advanced tab above you can select our variables.

And then when we select SP Site we get to select the SPList variable.

Wow, this is a game changer!

We can now dynamically select the lists using environment variables in Power Apps.

Replicating your lists

For this to really work, you need to be able to replciate your lists between development, test and production. For this I would recommend using PnP Powershell to export and import templates. if you need any help with this then just let me know on the chat.

Pieter Veenstra

Is your business still running on paper trails, sprawling Excel files, or ageing Access databases? There's a better way — and I can show you exactly what it looks like. I'm the Technical Director of Vantage 365, a Microsoft solutions consultancy working with clients across the UK, the Netherlands, and worldwide. For over 30 years I've been turning messy, manual business processes into clean, automated systems that save time, reduce errors, and give teams the visibility they need to make better decisions. SharePains is not just any blog run by a Microsoft MVP. Have you ever used Try-Catch in Power Automate? The original post about Try-Catch in Power Automate can still be found on this site, https://sharepains.com/2018/02/07/try-catch-finally-in-power-automate-flow/ Or have you ever used the Pieter’s method to avoid variables and speed up your flows? https://sharepains.com/2020/03/11/pieters-method-for-advanced-in-flows/ You can contact me using contact@sharepains.com

Pieter Veenstra

Is your business still running on paper trails, sprawling Excel files, or ageing Access databases? There's a better way — and I can show you exactly what it looks like. I'm the Technical Director of Vantage 365, a Microsoft solutions consultancy working with clients across the UK, the Netherlands, and worldwide. For over 30 years I've been turning messy, manual business processes into clean, automated systems that save time, reduce errors, and give teams the visibility they need to make better decisions. SharePains is not just any blog run by a Microsoft MVP. Have you ever used Try-Catch in Power Automate? The original post about Try-Catch in Power Automate can still be found on this site, https://sharepains.com/2018/02/07/try-catch-finally-in-power-automate-flow/ Or have you ever used the Pieter’s method to avoid variables and speed up your flows? https://sharepains.com/2020/03/11/pieters-method-for-advanced-in-flows/ You can contact me using contact@sharepains.com