Patch Sharepoint list but with LCM

(0) Share

Report

Posted on by Joost Cuppes

I've got 2 lists, Onboard & Onboard-DEV.

The Onboard is the production list and the other the development.

I can't get it to work to switch in environments in the patch function.

Based on a flow I know in which environment I am working and want to use this to switch in sharepoint list.

I tried the following query:

Patch(If(varEnvironment = " DEV",'Onboard-DEV', 'Onboard') ,{

Onboard is a direct copy of Onboard-DEV.

When using both separate they work, but combined not (then every column isn't recognized anymore).

The problem is that the application is a Standard application and can't be a premium (yet),

Is there any smart way? Or should I do the following (which i don't want).

if(varEnvironment = " DEV", 
 Patch('Onboard-DEV',{}),
 Patch('Onboard',{})
);

There are quite some columns which will be updated from here.

Last option is to add a column "Environment" and just put PROD/DEV over there and adjust all my other windows in the app.

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

BCBuizer 22,831 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JoostCuppes ,

Environment variables should be your go-to solution for this issue: https://learn.microsoft.com/en-us/power-apps/maker/data-platform/environmentvariables

Was this reply helpful? Yes No
Joost Cuppes 80 on at

Like
a
(0)

Report
Copy link

Link copied!

@BCBuizer But thats the big problem... When I am going to use this it switches to Premium, because the environment variables are saved in a dataverse table.

Was this reply helpful? Yes No
BCBuizer 22,831 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @JoostCuppes ,

According to the documentation no premium license is required for using environment variables: https://learn.microsoft.com/en-us/power-apps/maker/data-platform/environmentvariables#are-premium-licenses-required

Was this reply helpful? Yes No
vikas1606 206 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JoostCuppes ,

You can take a look at the below blog have a scenario of moving from one environment to another using environment variables. Also, As @BCBuizer mentioned it does not require any premium license.

https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Environment-variable-in-Power-Platform/ba-p/2065291

Was this reply helpful? Yes No
Joost Cuppes 80 on at

Like
a
(0)

Report
Copy link

Link copied!

@vikas1606 @BCBuizer Thanks! Thought because it was used in Dataverse it was Premium as well.... I have added the environment variable in the PowerApp and it switches to Premium again. (in Power Automate is works well)

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,831 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JoostCuppes ,

How do you 'add' to your app?

What you should do is to have at least 2 variables and your app in the same solution.

The first variable is for the site URL:

The second one is for the list and should use the Site URL variable:

If this is all set, go to the app and when adding the data source, select the Advanced tab to find your variables:

Site:

List:

After completion you will only see your SharePoint data source in the app data:

More importantly, the license designation remains standard:

As long as you set the environment variables correctly in the environments you export the solution to, you can use them without the need for a premium license.

Was this reply helpful? Yes No
Joost Cuppes 80 on at

Like
a
(1)

Report
Copy link

Link copied!

OMG @BCBuizer Never knew this! This works like a charm! Just added the Sharepoint List and going to try it! Thanks!

Was this reply helpful? Yes No