I remember seeing this a couple of years ago and not being able to fully grasp everything. Today I’m using this strategically. I used the video for a refresher… Thanks mate.
What will we do without your knowledge sessions like this? 🤔 .. Thanks, Reza, for this and for all your video sessions. Your service is so very valuable and very much appreciated.
this is brilliant , informative and much needed for me to get practical view of solutions and moving them across environments , very much appreciated!!!
Completed agreed. On the Power Apps community call next week, there is a lot more on environment variables - powerapps.microsoft.com/id-id/blog/may-19th-power-apps-community-call-multilingual-power-apps-environment-variables-and-more-environment-variables/
Thanks @Reza this is really helpful, I was really struggling with this issue as all apps were created in Production and have to migrate manually. Awesome :)
Thanks for sharing Reza. This has made me keen to explore how will the updates happen to say your App or flow, once you move your solution from say QA to Production.
Hey Reza! At 13:00 you mention that we need to remove the Environment Variable site value before we export the Solution- will I need to add that value BACK in after I export the Solution so I can continue work on that development Solution? And is this is a step I need to take EACH time I export a Solution with Environment Variables? I've been doing a lot of learning and work with Solutions, Environments, and Pipelines and your videos have been immensely helpful, thanks for all the great content!
Thank You. Managed vs Unmanaged is very well covered in the documentation - docs.microsoft.com/en-us/power-platform/alm/solution-concepts-alm#managed-and-unmanaged-solutions
@@RezaDorrani recently I appeared for an power platform interview and in the end I mentioned your name to interviewer that I follow Reza :) and he was aware of you... :) you create nice content and have presentation skills. Keep up the good work 💪
Thank u so much! Awesome content. Question, when creating a production sharepoint list(s), i believe the column names need to be the same. Is there an easy way to copy the test SP list to create a prod list or should i just manually create the new list and make sure the columns match?
Nice! Smart solution to support non-native (non dynamics) components like power apps power automate. It was working well with CDS before. I remember that in some scenarios it doesn't allow you to add existing flows to solution previously. Hoping that it works for everything now. Do we need cds enabled environment for it? How will it work for power apps list form with multi environment support now ( another video on that) ? Thanks Reza for this one. 😊👍Crystal clear.
Dataverse/CDS enabled environment is needed to work with solutions. Process of importing existing flows and apps to solutions has significantly improved. For SP customized list forms with Power Apps, I don't believe there are supported yet. For standalone Apps connected to SP Lists, this will work as demonstrated in the video.
@@RezaDorrani Thanks. Key ALM update announced does say that PowerApps list form will support ALM and multi environments. Roadmap is not clear. Could not imagine how but hoping environment variables will work for them as well. powerapps.microsoft.com/en-us/blog/key-alm-updates/
Thank you Reza for this video much appreciated. SharePoint will have different sites for dev and prod, is the flow shared between dev and prod? If we only have prod, can we go back and create dev and qa then package the prod and push into qa and dev? Thank you.
Tks a lot Reza !!!!! Just one question, every time that you bring some features from DEV to Prod environment, you need to compile the solution and import other time to production ???? The link URL to the App will always modified ? TKS so much!!!! 👏🏻
I noticed everytime you connect to a List, it creates one variable for Site and one variable for List. When you connect to multiple Lists in a Site, it still creates as many Site vairables as the List variables eventhough the Site value is same. Can we get rid of the redundant Site variables, Reza?
When you try and connect to a new list, you do have an option now where you can select an existing environment variable. That way it does not create a duplicate. I think I showed it on the community call. ua-cam.com/video/xCgIwP7EUw0/v-deo.html
Thanks for the video. I have one question. I have office 365 outlook connector added in my Powerapps app. This app is added in the solution. I was told to create connection reference for this but how do I use this connection reference in powerapps?
@@RezaDorrani yes, it got automatically added when solution was imported in target environment. So I do not need to create connection reference for powerapps, right?
Thanks for amazing video. Nicely explained. I have one issue- not able to find environment variables in power automate. Even Add dynamic conent is not showing in trigger
I will have to look at your flow in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Great video. I am having issues with Choice fields in PowerApps are not populating data though I set environment variable of the Prod environment. getting "The specified record was not found. Server Response: ListURL failed: List not found ". May be this could be bug from MS?
Awesome. Thank you. How would I handle running flows when I import an updated environment? Do I need self-recovering flows that will restart on every item and continue as needed?
Thanks for this. I have come up with an issue on the Environment Variable name because the 'The length of the 'displayname' attribute of the 'environmentvariabledefinition' entity exceeded the maximum allowed length of '100'."}}'. The naming convention for the SharePoint site is managed by the customer. Is there a way to get around this limit?
Great video (as always :) One question that really bothers me is that: is it possible to use this "Datasource Environment Variable" pointing to Sharepoint Site inside a dataflow? If not the "Datasource Environment Variable", than maybe other artifact/asset could be used intead? Suppose I have a bunch of dataflows that load data kept in Sharepoint site. I would like all these dataflows to use some kind of global parameter, that is visible for all of them and, which can be easily changed when necessary. Thank you!
Hi Reza, When i am creating a flow with in a solution, I do not see an option to choose environment variables(step mentioned at 8:55) in sharepoint connector(when a new item is created), Is there any thing changed recently?
@@RezaDorrani I do not see an option to "Add a custome item", Instead i see "Enter custom value", when i choose it, there is no option for dynamic content , when i create the flow it starts with new designer but changes to old and do not see an option to switch it to new.
Awesome Reza once again. The explanation was clear and understood. thank you so much!!! If you can answer this. 8:41 I do not see the option to "Add a custom item". Do we need to activate any feature? Or Do we need extra permission at Security Role area?
@@sharepoint2936 Cannot explain without looking at your issue in action. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza, thanks for this video. v. useful. Few issues I am facing if you could suggest. I am not getting the option to add the Environment var (you shown in 8:40) in Power Automate. Do we need to enable any settings ? 2. As shown in step 12:21, Flow component didn't add their connection reference - Office Outlook and SharePoint. PS - I am using Trial environment.
Hello Reza Dorrani, Thanks a lot for the helpful video sessions! I have a doubt, Is there a possibility to move APP and Power Automate Flows from One Environment to the Other Environment, That I want it to be only for the Developers. If So Whether the App and Flow will function which is already linked to data of existing sharepoint and environment ? TIA :)
Welcome! Not sure I understand your question. Solutions can move apps and flows. Once moved to target environment, you can either connect to new site and list using environment variables or connect to existing ones without using it.
Hello, thanks for this video! Do you think its possible that instead of using 2 separates sharepoint sites, we could use a single one with 2 sharepoint subsites ? thanks you
Hi Reza, thanks much for your Knowledge sharing for all out there and me. Can we do this for SQL connection as well? I see only 3 choices, SharePoint, dataverse, sap ERP under data sources in env variable.
I have not done any work with sql hence not sure. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
I think I waited too long to do this! When I try to add my cloud flow and add the "when and Item is created", I don't see the option for dynamic content to be able to select the environment variables. Also when I add the cloud flow, though the "maker" environment looks like power automate, the url reflects powerapps (i notice yours at the time pointed to flow). Maybe I need a premium license to add flows to a solution and have all the environment variables? Im going to keep hunting but hoping you have an answer! Thank you for getting me all this way!
Solutions requires Dataverse in environment, but user does not need to have premium license to create and use solutions. As for your issue, I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Thank you Reza! I heard from someone already that there is a known issue with triggers not working with environment variables. Either something has changed since a year ago when you posted this video or the issue is intermitent (only on some solutions). Im going to start over from scratch and see if the problem persists. Thanks for the prompt response!
Thank you so much for your videos. They are extremely helpful! Is there a way of doing this but with a SQL on prem data source instead of Sharepoint Lists?
Hi Reza, Can you advise, please? On the flow part, when you tried to add SharePoint site by clicking "+ Add a custom item" to pick parameters from dynamic content, I don't see the link of "Add a custom items" link under the Site Address. I already enabled "Experimental Features" under Settings of "View all Power Automate Settings". Thank you in advance.
That is not an experimental feature. Add a custom site addresses is a standard feature of flow. Might be some bug in your environment. You may want to create a ticket with MSFT.
Thanks a lot for this video. I have a question for you if possible. Is it possible to create a variable for a Microsoft form id and use it ? My idea was to create a first step when a form is submited and a second one to get the details. I have created an environment variable in my solution with the form id but wasn't able to use it in the two steps (the environment variable isn't displayed)
I have not tried this scenario but may be it is possible. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Very good informative video. I have a question - Suppose I imported the managed solution in my test or prod environment from Dev one. Now I have to change some component or add some customization to the app. So do I have to repeat the process again like first change it it dev then export it to test and prod or it will be visible to the environment automatically? 🤔
Hi Reza, I'm curious if we have deployed to another environment and we modify the original CDS table schema and redeploy to the same environment it will cause the error. How we can actually upgrade the table schema, for example one of the column is number type and we changed to text type.
Il be honest, I have not done much with solutions. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has ran into a similar issue.
Thank you so much Reza for this great walkthrough on environment variables. I can understand if we used environment variables in the canvas app and we want to move the solution from dev to prod. it is not needed to re-add the datasource to the app and reconnect it to the form so it will avoid replacing datacards and we will not lose the datacards logic validations in the form right?
Hi Reza so many thanks for all your tuto I'm learning so much with you thank you again. If you have time I'd like to ask you something... Is that possible to do the same things you do with solution in differents environment than in the same environment ?... One application for two users with differents sharepoint lists : how can I do the same kind of Environement Variables but in the same environnement?....
Hi Reza, we just have a single environment and I'm simply trying to point my app to a different SharePoint site and list. Basically I made a copy of the list for testing, built my app using that test copy, and now I want to point the app to the production version of the list. How can I do that?
I followed all your instructions except I used the Patch function instead of SubmitForm. However, after importing the solution to another environment, I encountered a 'Network error when using Patch function: You don't have permissions to edit this row' error when attempting to create a new record. Please help me resolve this issue.
I have not come experienced the mentioned issue and hence not sure what is the cause or fix for it. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Great Video! We used the same approach in our apps but after we export the solution and choose Sharepoint site and list from environment variables, it still somehow pulls data from old values. Not sure if this is a bug. Any idea?
HI. Great Work!. I have one doubt about Environment Variable Secrets. have one custom connector i am passing Secret Value in Text is not working. Or only that azure key vault is possible to passing a client secret
Excellent Rena as usual!! Thank so much for sharing. I would like to know how to move solutions from one tenant to another. That is painful. Also, I wonder if there is a way to duplicate the SharePoint site and lists so I don’t have to create them manually in production when I’ve already created them in development.
The process of moving solutions from one tenant to another is same as moving from one environment to another. To duplicate SharePoint sites and lists you would need to ensure that you create your lists via site designs feature in SPO. docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/site-design-overview You can even trigger site designs using flow. Long ago I had written an article on this - rezadorrani.com/index.php/2019/01/14/invoking-unlimited-actions-with-site-design-tasks-and-microsoft-flow/
You can also make use of PnP provisioning templates. They work great if to be used by support team rather than end users. They are more powerful as well. For end users Site design make most sense.
very well explained and problem solving video for soliution import export, but i have one question at 8:50. in flow i am unable add env variable, or unable to find parameter option. it sows custom value and cant fine env var in it.... pls explain stucked here
Save flow. Edit again and see if it works. If still none shows up, then I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza I have only one environment in powerapp but my datasource has 3 different setup Dev, QA and Prod. I usually have to create 3 setup for this app but the link changes are hard to handle is there a better approach I can take? Need your advice...
I cannot see any environment variables others have created and they cannot see or edit mine. Is there a way to share or change the owner of environment variables so everyone can use them?
The step taken for environment variables prior to exporting is important (shown in video). I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, I had a question, I have observed when I am passing a sharepoint site and sharepoint doc library as environment variables in a excel online connector (in power automate), I keep on getting 'Bad Request' error (observed only in excel online connector, for sharepoint or any other connector it works fine), but static address works fine. Could you please let me know if there a workaround for this?
Hi, I have not tried env variable with the excel online connector. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Is there any way to change the app name while transferring the solution, for example in dev enviro my app name i create service desk UAT and when moving to Prd , the app name should change like Service desk PRD.
@@RezaDorrani okay, in just normal export and import of the app, it has option to change the name while importing but in the solution i don't see such options, unless we change the name before exporting the managed solution. May be this is a workaround but not a solution
thank you for your amazing explanation I've try adding existing power automate flow into solution. but, the original flow in 'my flow' power automate was not there anymore. Thus, I copied back the flow and delete the solution. however, here come my problem. when I run the flow, it become redundant as run at two different places (my flow & solution). how can I turn off the flow in solution as it was not usable anymore?
Within solution, when you go to cloud flows, you should have option to turn them on or off. I will have to look at your solution in action to provide further guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, I follow you from a long time, thank you very for your huge support! I have found a strange issue with this flow. If I try your example with a form I got a problem loading choices values. I mean that after that I have imported the solution on the new environment (in a different tenant that has no access to the original source!) the gallery work correctly but I get an access denied on loading choices values coming from the form. Analizing the call I've found that power apps is still searching the choices from the original source. Have you got the same situation? Do you know any possible workarounds? Thank you very much as always!
I have not tried this cross tenant. This is a new feature and has had quite a few bugs which have been fixed recently. This could just be one of them. I don’t think there are any workarounds. This is just a feature that should work out of the box.
@@RezaDorrani Thank you for your response. In the meanwhile I made some tests. The problem is that when I open my App in a new tenant the App continues to reference the original list guid when loading data for the Choices function (whatching the invoke call I see that it search on the new site but with the guid of the original table and so it get 404 and the dropdown breaks). So I tried to remove the datasource from the App and then add it again using the environment variables and then the choices function finally got the correct table. By the way it seems that we still have to detach/atach datasources. Hopeful Microsoft will fix this bug soon because it is a very very useful feature when making app for thirdy party.
@@EmanueleFabbri I had to do that initially for an App in the same tenant as well. Thanks for sharing all your findings. Im sure it will help a lot of folks who are reading the comments.
Is it possible to import solution multiple times into production environment, giving each a unique name? I.e let’s say you had 3 service desk sites in your tenant and each wanted that same solution but linking to their sites/lists?
Better option would be to have 3 environments in Power Apps. As you move from one env to another, you just need to update the env variable to the respective SharePoint site/list as shown in the video.
Thank you for effort Reza, one thing I have noticed while using the sharepoint lists and sites in EV is that inside PowerApps under Data the data source EV always points towards the old data source. Let's say I start by putting my dev SPO site and list urls in the data source EVs and then migrate the solution to Test. Now I change the EV values as per my test SPO site and list urls and when I go inside PowerApps the data still points towards my dev URL values. I did a hard refresh, removed current and default values from the solution before exporting to Test but to no avail. Did you face something similar?
Hey reza, again great video. Do you know if its possible to manipulate the environment variables from inside a app or a flow? Actual i use sharepoint list to store needed variables which i need in runtime of my apps or flows. But think it would great to use a environment variables for it cause i am able to use them in flows without a special initalize.
Hello Reza, Thanks for this wonderful video. I am facing an issue with Choices in PowerApps. Choices('list name'.'choice type column') This statement is giving an error after import - list not found. Is there any issue?
Hi Reza, I have been encountering errors since deploying my App to a different environment. Do I also need to update the Environment Permissions or any permissions in general? These are the errors i encounter: 1. Error when trying to retrieve data from the network 2. Flow.run failed.....The server did not receive a response from an upstream server....
I have not experienced the mentioned issue and hence not sure what the cause could be. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Video shows how to create environment variables for data source. You can create variable of type text as well and then use it in apps and flows. You can also check this video - ua-cam.com/video/Xo-TvZ9N3BM/v-deo.html
I remember seeing this a couple of years ago and not being able to fully grasp everything. Today I’m using this strategically. I used the video for a refresher… Thanks mate.
Excellent! Thanks so much for the revisit.
Thanks for replying on video which was published 2 years ago.
Thank You
What will we do without your knowledge sessions like this? 🤔 .. Thanks, Reza, for this and for all your video sessions. Your service is so very valuable and very much appreciated.
Thank You so much for liking and watching my videos.
Each time I need to gain some PowerApps knowledge, Reza your channel is always my first choice!
Thanks Eric!
I wish I had found this video earlier. Thank you Reza! Your service to us in the community is invaluable! Thank you again!
Glad it was helpful!
Agree....much appreciated ! thanks Reza!
From zero to hero in power apps developer with the help of Reza videos ❤️❤️❤️
Thanks so much
Thank you Reza for making the things easier for us. your content is invaluable.
this is brilliant , informative and much needed for me to get practical view of solutions and moving them across environments , very much appreciated!!!
Great to hear!
No words to describe the value of this video, thank you Reza for sharing your knowledge with us.
Thanks Saulo
Asusual amazing, you are the KINGPIN of Powerapps .....KUDOS
Thank You so much Sridhar
Again Reza, your videos have been a time saver. Awesome work and thank you.
Glad to hear it!
Reza, you are the man! Thanks for this super helpful video and for taking the time to share your knowledge.
You are most welcome. Thank You for watching the video.
Perfect timing Reza, I have been looking at Solutions and understand how they work for Dataverse Tables but was wondering how SP sites and lists work.
These new data source variables make it easier to work with SP sites and lists
Wonderful!! Thank you for sharing and updating us.
You bet!
Valeu!
Obrigado
Awesome. I have a lot of fun learning with you. Thanks Reza
Happy to hear that!
Thank you so much sir🥰 really very informative and understanding. i was tired of searching for how to achieve this. Really thgank you so much
You are most welcome
Many thanks for sharing... this is so powerful and makes life so much easier going forward 🙂
Completed agreed. On the Power Apps community call next week, there is a lot more on environment variables - powerapps.microsoft.com/id-id/blog/may-19th-power-apps-community-call-multilingual-power-apps-environment-variables-and-more-environment-variables/
@@RezaDorrani Perfect cheers... Now in my calendar!
Hi Reza,
Thanks for the wonderful explanation about the ALM
You’re most welcome
You are awesome boss 😊 This is an advanced learning topic for me but great video, Thank you
Glad to hear that! I try to include a mix of beginner and advanced topics to keep things interesting 😊
Excellent Reza...thanks a lot for the video
You are most welcome
You are the man!!! Great resource, thanks for sharing!! :)
You bet!
This is really awesome! I was setting up the connections manually 😪
It surely is awesome
Thanks @Reza this is really helpful, I was really struggling with this issue as all apps were created in Production and have to migrate manually. Awesome :)
You're very welcome!
This is so valuable, thank you Reza
Most welcome
Thanks for sharing Reza. This has made me keen to explore how will the updates happen to say your App or flow, once you move your solution from say QA to Production.
I feel every SharePoint and Power Platform related solution needs to use these variables going forward.
Hey Reza!
At 13:00 you mention that we need to remove the Environment Variable site value before we export the Solution- will I need to add that value BACK in after I export the Solution so I can continue work on that development Solution? And is this is a step I need to take EACH time I export a Solution with Environment Variables?
I've been doing a lot of learning and work with Solutions, Environments, and Pipelines and your videos have been immensely helpful, thanks for all the great content!
No, once per env variable
Great video Reza! What I currently do is to create a Choice column that represent the environments 😅. I will try this out and see which is better.
Thanks for watching
This is a great tutorial. Thank you!
Your most welcome
Excellent video! Thank you for sharing
Thank you Praveen
the best of the bests!!
Thanks Juan!
Thanks Reza 😊...This is very useful video
My pleasure 😊
perfectly explained. Thanks for the video..
You're most welcome!
Thank you! Amazing content.
Glad you enjoyed it!
Ah, long awaited feature.
A true game changer for Power Platform projects with SharePoint as a data source
Very awesome feature
Much needed.
Thanks.👍🏼
Can you pls create detailed video for managed vs unmanaged?
It will be helpful.
Thank You.
Managed vs Unmanaged is very well covered in the documentation - docs.microsoft.com/en-us/power-platform/alm/solution-concepts-alm#managed-and-unmanaged-solutions
Wonderful video
Thank You
Awesome, thanks for sharing 😊
Thanks Viraj
Fantastic tutorial
Thanks
Very well explained :) thanks for sharing
Thanks Ashish
@@RezaDorrani recently I appeared for an power platform interview and in the end I mentioned your name to interviewer that I follow Reza :) and he was aware of you... :) you create nice content and have presentation skills. Keep up the good work 💪
@@MrDashingAshish Wow. I feel it is all thanks to my subscribers who constantly share my content.
I hope you cracked the interview 💪
@@MrDashingAshish Congrats!
Very nice .. it's very helpful.
Glad it was helpful!
Thank u so much! Awesome content. Question, when creating a production sharepoint list(s), i believe the column names need to be the same. Is there an easy way to copy the test SP list to create a prod list or should i just manually create the new list and make sure the columns match?
Column names and schema have to match.
SharePoint has a concept of creating lists using JSON schema. I recommend checking SharePoint documentation
What can i say on this video , except Wow. Migrate a powerapps to an another environnement will be no pain now
Awesome!
common knowledge, this is how we have been doing it for a long time.
Very nice.
Thank you Reza 🙏
Welcome!!
Nicely explained
Thank You
Nice! Smart solution to support non-native (non dynamics) components like power apps power automate. It was working well with CDS before. I remember that in some scenarios it doesn't allow you to add existing flows to solution previously. Hoping that it works for everything now. Do we need cds enabled environment for it? How will it work for power apps list form with multi environment support now ( another video on that) ? Thanks Reza for this one. 😊👍Crystal clear.
Dataverse/CDS enabled environment is needed to work with solutions.
Process of importing existing flows and apps to solutions has significantly improved.
For SP customized list forms with Power Apps, I don't believe there are supported yet.
For standalone Apps connected to SP Lists, this will work as demonstrated in the video.
@@RezaDorrani Thanks. Key ALM update announced does say that PowerApps list form will support ALM and multi environments. Roadmap is not clear. Could not imagine how but hoping environment variables will work for them as well. powerapps.microsoft.com/en-us/blog/key-alm-updates/
I hope so too.
Thanks Raza!
👍
Brilliant
Thanks
Thank you Reza for this video much appreciated. SharePoint will have different sites for dev and prod, is the flow shared between dev and prod? If we only have prod, can we go back and create dev and qa then package the prod and push into qa and dev? Thank you.
Check ua-cam.com/video/Xo-TvZ9N3BM/v-deo.html
Flow is not shared. There will be 2 separate flows.
Tks a lot Reza !!!!!
Just one question, every time that you bring some features from DEV to Prod environment, you need to compile the solution and import other time to production ????
The link URL to the App will always modified ?
TKS so much!!!! 👏🏻
Yes, you would need to export solution and import.
It will keep app URL same in downstream environments.
Give it a try and check.
I noticed everytime you connect to a List, it creates one variable for Site and one variable for List. When you connect to multiple Lists in a Site, it still creates as many Site vairables as the List variables eventhough the Site value is same. Can we get rid of the redundant Site variables, Reza?
When you try and connect to a new list, you do have an option now where you can select an existing environment variable. That way it does not create a duplicate.
I think I showed it on the community call. ua-cam.com/video/xCgIwP7EUw0/v-deo.html
Awesome!! Thank you😆✨
Thanks Tetsuya
Thanks for the video. I have one question. I have office 365 outlook connector added in my Powerapps app. This app is added in the solution. I was told to create connection reference for this but how do I use this connection reference in powerapps?
It does so automatically
learn.microsoft.com/en-us/power-apps/maker/data-platform/create-connection-reference
@@RezaDorrani yes, it got automatically added when solution was imported in target environment. So I do not need to create connection reference for powerapps, right?
@@673ritesh As long as you build in solutions, you don't have to do anything else
Thanks for amazing video. Nicely explained.
I have one issue- not able to find environment variables in power automate. Even Add dynamic conent is not showing in trigger
I will have to look at your flow in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Great video. I am having issues with Choice fields in PowerApps are not populating data though I set environment variable of the Prod environment. getting "The specified record was not found. Server Response: ListURL failed: List not found ". May be this could be bug from MS?
This one is a known bug. Choice fields cause issues.
Awesome. Thank you. How would I handle running flows when I import an updated environment? Do I need self-recovering flows that will restart on every item and continue as needed?
The flows that are in running mode will continue to use the previous flow schema.
New flow runs will adhere to the updates pushed out via solutions.
Thanks for this. I have come up with an issue on the Environment Variable name because the 'The length of the 'displayname' attribute of the 'environmentvariabledefinition' entity exceeded the maximum allowed length of '100'."}}'. The naming convention for the SharePoint site is managed by the customer. Is there a way to get around this limit?
You can create the variable directly in solution and then connect it in App.
Check ua-cam.com/video/xCgIwP7EUw0/v-deo.html
Great video (as always :) One question that really bothers me is that: is it possible to use this "Datasource Environment Variable" pointing to Sharepoint Site inside a dataflow? If not the "Datasource Environment Variable", than maybe other artifact/asset could be used intead? Suppose I have a bunch of dataflows that load data kept in Sharepoint site. I would like all these dataflows to use some kind of global parameter, that is visible for all of them and, which can be easily changed when necessary. Thank you!
I don't think so it is supported with dataflows
Hi Reza, When i am creating a flow with in a solution, I do not see an option to choose environment variables(step mentioned at 8:55) in sharepoint connector(when a new item is created), Is there any thing changed recently?
You need to select custom item. Check in both new and old cloud flow designer.
@@RezaDorrani I do not see an option to "Add a custome item", Instead i see "Enter custom value", when i choose it, there is no option for dynamic content , when i create the flow it starts with new designer but changes to old and do not see an option to switch it to new.
Here is the image of what is see: drive.google.com/file/d/13iPklKkLcH8BLMRXNAkQGTZA2rgKOknR/view?usp=sharing
I have not experienced this, hence not sure.
I suggest posting your issue on forums community.powerplatform.com/
Hi Reza, great video. Quick question... Do you need to be a global admin to run this?
As long as you have environment maker access you should be able to work with this.
@@RezaDorrani Many thanks
Awesome Reza once again. The explanation was clear and understood. thank you so much!!! If you can answer this.
8:41 I do not see the option to "Add a custom item". Do we need to activate any feature? Or Do we need extra permission at Security Role area?
I have the experimental feature for flow turned ON.
In your scenario, if you open list dropdown, at the end you will get the custom option.
@@RezaDorrani unable to add parameter value or unable to select enviornment variable pls explain
@@sharepoint2936 Cannot explain without looking at your issue in action. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani ok thanks I'll post on community
Thanks Raza
Always welcome
Hi Reza, thanks for this video. v. useful.
Few issues I am facing if you could suggest. I am not getting the option to add the Environment var (you shown in 8:40) in Power Automate. Do we need to enable any settings ?
2. As shown in step 12:21, Flow component didn't add their connection reference - Office Outlook and SharePoint.
PS - I am using Trial environment.
Seems weird. There is no setting as such.
@@RezaDorrani - Ok let me google once more time. thanks
Hi Reza, thank you for the great content you share. Is it possible to point environment variables to Document Library? My flow failed when I tried it.
Should be possible but not something I have tried
@@RezaDorrani, thank you. This is the error I am getting "Root folder is not found". When I put the library name instead, it works with no issue.
@@stevebekele4083 Not sure. I will recommend posting your issue with screenshots on forums powerusers.microsoft.com/
Hello Reza Dorrani,
Thanks a lot for the helpful video sessions!
I have a doubt, Is there a possibility to move APP and Power Automate Flows from One Environment to the Other Environment, That I want it to be only for the Developers. If So Whether the App and Flow will function which is already linked to data of existing sharepoint and environment ?
TIA :)
Welcome!
Not sure I understand your question.
Solutions can move apps and flows. Once moved to target environment, you can either connect to new site and list using environment variables or connect to existing ones without using it.
Hello, thanks for this video! Do you think its possible that instead of using 2 separates sharepoint sites, we could use a single one with 2 sharepoint subsites ? thanks you
I have not tried with subsites, hence not sure.
Hi Reza, thanks much for your Knowledge sharing for all out there and me. Can we do this for SQL connection as well? I see only 3 choices, SharePoint, dataverse, sap ERP under data sources in env variable.
I have not done any work with sql hence not sure. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
I think I waited too long to do this! When I try to add my cloud flow and add the "when and Item is created", I don't see the option for dynamic content to be able to select the environment variables. Also when I add the cloud flow, though the "maker" environment looks like power automate, the url reflects powerapps (i notice yours at the time pointed to flow). Maybe I need a premium license to add flows to a solution and have all the environment variables? Im going to keep hunting but hoping you have an answer! Thank you for getting me all this way!
Solutions requires Dataverse in environment, but user does not need to have premium license to create and use solutions.
As for your issue, I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Thank you Reza! I heard from someone already that there is a known issue with triggers not working with environment variables. Either something has changed since a year ago when you posted this video or the issue is intermitent (only on some solutions). Im going to start over from scratch and see if the problem persists. Thanks for the prompt response!
Awesome it's
Thank you! Cheers!
Thank you so much for your videos. They are extremely helpful! Is there a way of doing this but with a SQL on prem data source instead of Sharepoint Lists?
Currently, data source environment variables only support SharePoint.
Just a query, if we are using Site Data Source Environment variables, how the current user login will be taken for the Item Addition and Patching?
Current logged in user logic would work as normal. No change there. User would need access to that SharePoint site.
Hi Reza, Can you advise, please? On the flow part, when you tried to add SharePoint site by clicking "+ Add a custom item" to pick parameters from dynamic content, I don't see the link of "Add a custom items" link under the Site Address. I already enabled "Experimental Features" under Settings of "View all Power Automate Settings". Thank you in advance.
That is not an experimental feature.
Add a custom site addresses is a standard feature of flow.
Might be some bug in your environment.
You may want to create a ticket with MSFT.
Thanks a lot for this video. I have a question for you if possible. Is it possible to create a variable for a Microsoft form id and use it ? My idea was to create a first step when a form is submited and a second one to get the details. I have created an environment variable in my solution with the form id but wasn't able to use it in the two steps (the environment variable isn't displayed)
I have not tried this scenario but may be it is possible. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Very good informative video.
I have a question - Suppose I imported the managed solution in my test or prod environment from Dev one. Now I have to change some component or add some customization to the app. So do I have to repeat the process again like first change it it dev then export it to test and prod or it will be visible to the environment automatically? 🤔
You will need to make updates in dev and re-export. There are azure devops pipelines that help in automating this.
Hi Reza, I'm curious if we have deployed to another environment and we modify the original CDS table schema and redeploy to the same environment it will cause the error. How we can actually upgrade the table schema, for example one of the column is number type and we changed to text type.
Il be honest, I have not done much with solutions. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has ran into a similar issue.
@@RezaDorrani thanks for your quick response!!!
Thank you so much Reza for this great walkthrough on environment variables. I can understand if we used environment variables in the canvas app and we want to move the solution from dev to prod. it is not needed to re-add the datasource to the app and reconnect it to the form so it will avoid replacing datacards and we will not lose the datacards logic validations in the form right?
In an ideal world Yes. But I have noticed some challenges with these environment variables.
Hi Reza so many thanks for all your tuto I'm learning so much with you thank you again.
If you have time I'd like to ask you something...
Is that possible to do the same things you do with solution in differents environment than in the same environment ?... One application for two users with differents sharepoint lists : how can I do the same kind of Environement Variables but in the same environnement?....
You can create multiple environment variables - one for each type of list.
It could be used in same or different environments.
While building flows in Power Automate will environment variables also be created by default? Or is this feature only available in power apps?
Flows use connection references when built in solution context. I will recommend reading documentation on connection references.
Hi Reza, we just have a single environment and I'm simply trying to point my app to a different SharePoint site and list. Basically I made a copy of the list for testing, built my app using that test copy, and now I want to point the app to the production version of the list. How can I do that?
Simply change the environment variable to point to new list.
Again Thanks was very useful, just wondering if we can use the environment variable within the Powerapps sendmailV2?
Possible but currently reading environment variable in Power App requires querying Dataverse.
ua-cam.com/video/xCgIwP7EUw0/v-deo.html
@@RezaDorrani Sorry I should have mentioned earlier but that will require a premium license which I want to avoid.
@@rahullko28 That is the only option for now. Better to use flow.
I followed all your instructions except I used the Patch function instead of SubmitForm. However, after importing the solution to another environment, I encountered a 'Network error when using Patch function: You don't have permissions to edit this row' error when attempting to create a new record. Please help me resolve this issue.
I have not come experienced the mentioned issue and hence not sure what is the cause or fix for it. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Great Video! We used the same approach in our apps but after we export the solution and choose Sharepoint site and list from environment variables, it still somehow pulls data from old values. Not sure if this is a bug. Any idea?
I am mainly referring to choice fields :)
Thank You.
If referring to Choices function for Choice fields, then yes, it is a bug currently.
It's a bug.
@@RezaDorrani Thanks for the reply. Good to know. I thought I was doing something wrong 😄
HI. Great Work!. I have one doubt about Environment Variable Secrets. have one custom connector i am passing Secret Value in Text is not working. Or only that azure key vault is possible to passing a client secret
AKV is the preferred option
@@RezaDorrani any other option?
@@yogeshm8344 I am not aware of any other option
Excellent Rena as usual!! Thank so much for sharing. I would like to know how to move solutions from one tenant to another. That is painful. Also, I wonder if there is a way to duplicate the SharePoint site and lists so I don’t have to create them manually in production when I’ve already created them in development.
The process of moving solutions from one tenant to another is same as moving from one environment to another.
To duplicate SharePoint sites and lists you would need to ensure that you create your lists via site designs feature in SPO.
docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/site-design-overview
You can even trigger site designs using flow. Long ago I had written an article on this - rezadorrani.com/index.php/2019/01/14/invoking-unlimited-actions-with-site-design-tasks-and-microsoft-flow/
You can also make use of PnP provisioning templates. They work great if to be used by support team rather than end users. They are more powerful as well. For end users Site design make most sense.
@@parwejp + 1 for PnP templates
@@RezaDorrani thank you so much! I will look into this.
very well explained and problem solving video for soliution import export, but i have one question at 8:50. in flow i am unable add env variable, or unable to find parameter option. it sows custom value and cant fine env var in it.... pls explain stucked here
Save flow. Edit again and see if it works.
If still none shows up, then I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Thank u very much 👍 it works save & then try 👍👍👍👍
Hi Reza
I have only one environment in powerapp but my datasource has 3 different setup Dev, QA and Prod. I usually have to create 3 setup for this app but the link changes are hard to handle is there a better approach I can take? Need your advice...
You would need multiple environments to truly take advantage of environment variables and ALM.
I cannot see any environment variables others have created and they cannot see or edit mine. Is there a way to share or change the owner of environment variables so everyone can use them?
The step taken for environment variables prior to exporting is important (shown in video).
I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Thanks Reza for such valuable video and knowledge sessions.
Still environment variables can be used only for SharePoint as a data source?
You can check and see :)
I believe Yes
Hi Reza,
I had a question, I have observed when I am passing a sharepoint site and sharepoint doc library as environment variables in a excel online connector (in power automate), I keep on getting 'Bad Request' error (observed only in excel online connector, for sharepoint or any other connector it works fine), but static address works fine. Could you please let me know if there a workaround for this?
Hi, I have not tried env variable with the excel online connector.
I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Is there any way to change the app name while transferring the solution, for example in dev enviro my app name i create service desk UAT and when moving to Prd , the app name should change like Service desk PRD.
I'm not aware of any option to do that
@@RezaDorrani okay, in just normal export and import of the app, it has option to change the name while importing but in the solution i don't see such options, unless we change the name before exporting the managed solution. May be this is a workaround but not a solution
That would not be a solution.
thank you for your amazing explanation
I've try adding existing power automate flow into solution.
but, the original flow in 'my flow' power automate was not there anymore.
Thus, I copied back the flow and delete the solution. however, here come my problem. when I run the flow, it become redundant as run at two different places (my flow & solution).
how can I turn off the flow in solution as it was not usable anymore?
Within solution, when you go to cloud flows, you should have option to turn them on or off.
I will have to look at your solution in action to provide further guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, I follow you from a long time, thank you very for your huge support! I have found a strange issue with this flow. If I try your example with a form I got a problem loading choices values. I mean that after that I have imported the solution on the new environment (in a different tenant that has no access to the original source!) the gallery work correctly but I get an access denied on loading choices values coming from the form. Analizing the call I've found that power apps is still searching the choices from the original source. Have you got the same situation? Do you know any possible workarounds? Thank you very much as always!
I have not tried this cross tenant. This is a new feature and has had quite a few bugs which have been fixed recently. This could just be one of them. I don’t think there are any workarounds. This is just a feature that should work out of the box.
@@RezaDorrani Thank you for your response. In the meanwhile I made some tests. The problem is that when I open my App in a new tenant the App continues to reference the original list guid when loading data for the Choices function (whatching the invoke call I see that it search on the new site but with the guid of the original table and so it get 404 and the dropdown breaks). So I tried to remove the datasource from the App and then add it again using the environment variables and then the choices function finally got the correct table. By the way it seems that we still have to detach/atach datasources. Hopeful Microsoft will fix this bug soon because it is a very very useful feature when making app for thirdy party.
@@EmanueleFabbri I had to do that initially for an App in the same tenant as well. Thanks for sharing all your findings. Im sure it will help a lot of folks who are reading the comments.
Is it possible to import solution multiple times into production environment, giving each a unique name? I.e let’s say you had 3 service desk sites in your tenant and each wanted that same solution but linking to their sites/lists?
Better option would be to have 3 environments in Power Apps. As you move from one env to another, you just need to update the env variable to the respective SharePoint site/list as shown in the video.
Great video! Are environment variables supported for any other connector besides SharePoint? I can't seem to get it working for SQL Server.
Data source environment variables only supports SharePoint for now
Thank you for effort Reza, one thing I have noticed while using the sharepoint lists and sites in EV is that inside PowerApps under Data the data source EV always points towards the old data source. Let's say I start by putting my dev SPO site and list urls in the data source EVs and then migrate the solution to Test. Now I change the EV values as per my test SPO site and list urls and when I go inside PowerApps the data still points towards my dev URL values. I did a hard refresh, removed current and default values from the solution before exporting to Test but to no avail. Did you face something similar?
I have not faced this. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani same happened in my case also
@@kiruthikas1073 Best to post your issue on the forums
Hey reza, again great video. Do you know if its possible to manipulate the environment variables from inside a app or a flow? Actual i use sharepoint list to store needed variables which i need in runtime of my apps or flows. But think it would great to use a environment variables for it cause i am able to use them in flows without a special initalize.
I believe you need to update them from within the Solutions interface. Storing variables as env variables is a better option that SP list.
Hello Reza, Thanks for this wonderful video. I am facing an issue with Choices in PowerApps.
Choices('list name'.'choice type column')
This statement is giving an error after import - list not found.
Is there any issue?
Data source env variables are in preview. I believe this is a known issue. Hopefully these will be fixed soon.
@@RezaDorrani Hey Reza is there any update on this?
@@Recker096 I am not following up on this. Best place to report this would be on the ideas board on the forums.
Hi Reza,
I have been encountering errors since deploying my App to a different environment. Do I also need to update the Environment Permissions or any permissions in general?
These are the errors i encounter:
1. Error when trying to retrieve data from the network
2. Flow.run failed.....The server did not receive a response from an upstream server....
I have not experienced the mentioned issue and hence not sure what the cause could be.
I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
How can I create an env variable (s) that I can use to update deep links in my flow emails?
Video shows how to create environment variables for data source. You can create variable of type text as well and then use it in apps and flows. You can also check this video - ua-cam.com/video/Xo-TvZ9N3BM/v-deo.html