Тёмный

Power Apps and Automate Solutions and Environment Variables for SharePoint 

Shane Young
Подписаться 163 тыс.
Просмотров 39 тыс.
50% 1

Are you ready to make your SharePoint based apps and flows more portable? Then you need Solutions and Environment variables. These handy packages allow you to move your apps and flows and change the connections all without pain and suffering. But there are lots of little pieces to learn so this video takes you through everything from beginning to end. Create the Solution, the lists, the apps, the flows and the move it all to a new environment. Not hard, just lots of little pieces to learn.
0:00 Power Apps Solutions and SharePoint Environment Variables
1:20 What is a Power Platform Solution and an Environment Variable
3:39 Create a Solution and discuss Publishers
5:14 Create a canvas app in the solution and enable the Setting create environment variables when adding data sources
7:40 Create the SharePoint list to use with your Solution
8:50 Add your SharePoint data source and automatically create the Environment Variables
12:25 Create a Power Automate flow using Environment Variables
15:00 Connection Reference in your solution and add Advanced - Required Objects
16:30 Remove the Current list and Current site from your Environment Variables
18:09 Publish all changes and Export your solution
19:27 Managed vs. unmanaged solutions overview
21:46 Import Solution, Setup your Connections, and update your Environment Variables
23:51 Create SharePoint list from existing list in the other site
29:21 Deleting part or all of your Solution from the Solution or the Environment
Power Apps Consulting and training at www.PowerApps911.com

Наука

Опубликовано:

 

23 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 179   
@oysterhoys
@oysterhoys Год назад
8 months later I watch it again. So great all this information !!! ( Using Env vars in solutions is not Premium, but using Env vars inside your App is ! )
@ShanesCows
@ShanesCows Год назад
Glad it was helpful!
@user-me8xb1wi5g
@user-me8xb1wi5g 3 месяца назад
What about Global variables in the app? Is that premium?
@DaniilStanisevschi
@DaniilStanisevschi Год назад
Excellent video Shane! Yes, long videos are always encouraged and I don't think anyone has an issue with leaving in the goof ups - we all make them daily in our own development! Great to see the solutions feature in action, we struggled with dev/uat/prod life cycle not having this before.
@ShanesCows
@ShanesCows Год назад
Thanks Daniil! 😎
@cmacdhon
@cmacdhon Год назад
I really enjoy your longer and more detailed videos. They help me to get into the correct headspace, and the longer I have my headphones on, the longer I can go without someone bugging me!
@ShanesCows
@ShanesCows Год назад
Glad you like them and happy to help you stay safe in your bubble longer!
@D3-2023
@D3-2023 Год назад
Yes I like long and every teaching "mess up."
@ShanesCows
@ShanesCows Год назад
Thanks for the feedback.
@jonathanwalker2543
@jonathanwalker2543 Год назад
This is fantastic! I have to rebuild a lot of InfoPath forms and Nintex workflows for our transition to SPO. With this I can start building the replacements even if we don’t have the final landing spot created.
@ShanesCows
@ShanesCows Год назад
Nice!
@user-me8xb1wi5g
@user-me8xb1wi5g 3 месяца назад
(27:30) - Wow, nice bug. And yes we like the long videos as it gives a straight overview. Much appreciated!
@ShanesCows
@ShanesCows 3 месяца назад
Cool, thanks for the feedback. 🤩
@berggrog1
@berggrog1 10 месяцев назад
Thanks Again Shane for the video. Really like the Add Dependency tips and explaining it simply
@ShanesCows
@ShanesCows 10 месяцев назад
Glad it was helpful!
@guyw.9410
@guyw.9410 Год назад
As if you knew we were struggling with it! 😉 Great video with perfect timing! Thx Shane!
@ShanesCows
@ShanesCows Год назад
Happy to help!
@guyinazo
@guyinazo Год назад
This is something that answer many questions that I have needed for a while! Thanks again for a great video
@ShanesCows
@ShanesCows Год назад
Very welcome!
@StephanOnisick
@StephanOnisick 9 месяцев назад
Really Nice Coverage! Went through all the basic pieces.
@ShanesCows
@ShanesCows 9 месяцев назад
Glad you liked it!
@MandyMcPhail
@MandyMcPhail Год назад
Shane, this was so useful, thank you! I'd tried looking into the Microsoft Learn details on how to do this but my brain doesn't work so well with those written articles. Your video covered the essentials to get me over the start line as I need to rework a complex flow before sharing it with a wider audience and in the knowledge that we'll be moving our entire tenant to another in just a few months!
@ShanesCows
@ShanesCows Год назад
Glad it was helpful! Good luck with the move. :)
@giorgiosurian2190
@giorgiosurian2190 Год назад
Love working with you guys!!
@ShanesCows
@ShanesCows Год назад
Thanks Giorgio! 🐶
@franknielsen3219
@franknielsen3219 Год назад
Excellent and great explanation. For me it will be a step learning curve but your videos are helping a lot. THX for all the effort you put into it 👌👌
@ShanesCows
@ShanesCows Год назад
You are welcome Frank. Appreciate your support! 😎
@sylviarojas2640
@sylviarojas2640 9 месяцев назад
Thank you! good information as always!
@ShanesCows
@ShanesCows 9 месяцев назад
You bet!
@waynepeinke
@waynepeinke Год назад
Great explanation of a use function that will really help with maintaining and updating app across test, dev and prod environments. We also use external Devs and it is a challenge to develop outside our tenant and then bring completed apps in. This is a great step in the right direction.
@ShanesCows
@ShanesCows Год назад
Thanks Wayne!
@oluwatobipaul6171
@oluwatobipaul6171 Год назад
Thanks for this content. I have always wanted to try out the environmental variable
@ShanesCows
@ShanesCows Год назад
They are interesting 🧐
@calebessilva
@calebessilva Год назад
Thanks for that, Shane!
@ShanesCows
@ShanesCows Год назад
Happy to help. Have a great day. 🐶
@johanromero5429
@johanromero5429 4 месяца назад
What a video man ! You are a really master of this ! Thank you very much, this video saved me to live hard times jejeje
@ShanesCows
@ShanesCows 4 месяца назад
You're welcome!
@user-bt7cb3bx7k
@user-bt7cb3bx7k Год назад
As always… Great stuff :)
@ShanesCows
@ShanesCows Год назад
Thank you!
@skimka919
@skimka919 9 месяцев назад
Super liked this video, i learned so much !! thank you
@ShanesCows
@ShanesCows 9 месяцев назад
Glad you enjoyed it!
@chahineatallah2636
@chahineatallah2636 10 месяцев назад
amazing video! everytime we learn something new
@ShanesCows
@ShanesCows 10 месяцев назад
Happy to hear that!
@varzden292
@varzden292 Год назад
Thanks a million!
@ShanesCows
@ShanesCows Год назад
Glad it helped. You are welcome.
@AnisAchkar
@AnisAchkar Год назад
Shane, always a pleasure to see the content you create. Each video is as special as the next one. Thank you so much for that. A quick question for you: If I am importing a solution from my environment to my client's environment, do I have to re-create all the SharePoint lists? Or is there a way for me to import them?
@LeoBaumer
@LeoBaumer Месяц назад
Thanks!
@ShanesCows
@ShanesCows Месяц назад
Appreciate the support. 🤩
@willemv5679
@willemv5679 Год назад
Great video, I love the way it's explained, I was always working on "live" data..... However, I've now some apps running and moved them by exporting the app, not the solution. Now the challenge will be to have the current apps setup in a solution and not having to change the end user link to the app.....
@ShanesCows
@ShanesCows Год назад
Yeah solutions after the fact are more challenging 😑 Good luck.
@paolovr1970
@paolovr1970 Год назад
Thanks Shane 🙏🙏🙏
@ShanesCows
@ShanesCows Год назад
Happy to help. Have a great day. 🐶
@taaee
@taaee Год назад
Nice "small" clues that make the big difference! Thank you Shane. I was wondering how much time you toke to go over the steps until get the right path... 🤣. Even with you excellent explanation I had to reproduce 3 times until get things working
@ShanesCows
@ShanesCows Год назад
It just depends. Something like this it took several goes and I had someone to ask questions to. 🫤 Other topics just rattle out of my mouth. 😁
@zylka172
@zylka172 Год назад
Shane, this is another interesting, helpful video in you collection, thank you! I just took on ownership of a live app that I wasn't involved in with the build, and there is a lot of logic behind the many screens that I'm trying to figure out. Since the app is live and has hundreds of users, your solution to use Solutions seems to be perfect. Just to make sure: If I start a new Solution in my DEV env, I can pull in the PROD app from the PROD env and basically 'play' with it, without doing any damage to the live app? And then, when I have figured all dependencies and logic out, I could theoretically move it back into the PROD solution space, copy the live user info into a new PROD list, and connect that to the updated from DEV-to-PROD solution?
@joaomacaumaia3834
@joaomacaumaia3834 Год назад
excelente!!!
@ShanesCows
@ShanesCows Год назад
Gracias! (Sorry that is the limit on my Espanol!) 😊
@joaomacaumaia3834
@joaomacaumaia3834 Год назад
@@ShanesCows Portuguese actually, but close 💪💪 the level of detail was spot on! Do you have any of this type for O365 groups management in environments and solution? Best regards 🙏
@1culcat
@1culcat 7 месяцев назад
Hey Shane! Fell upon your channel and have been digging into your videos. GREAT CONTENT! Loving it! I recently got into using solution but can you confirm that after exporting a solution, you should remap the site and list since you had to remove it for the export?
@waynepeinke
@waynepeinke 10 месяцев назад
Great video.. man did I make life hard for myself... if I was following a recipe for chocolate cake, I would have ended up with oatmeal cookies! Gotta learn to follow more closely! 🤣
@ShanesCows
@ShanesCows 10 месяцев назад
Sorry to hear that but guessing by the comment you got it sorted so congrats. 😎😎
@tamasvarga6922
@tamasvarga6922 Год назад
Great and valuable content again, thanks Shane! If I have an existing app with all its datasources, and the automatically create env variables when adding datasources option was not set initially, can I set it later? I understand I can create those variables manually in the solution, but how can I configure the existing app to start using the variable for its datasources?
@user-me8xb1wi5g
@user-me8xb1wi5g 3 месяца назад
This right here. Did you find an answer? I'll be testing this out.
@alangilman2886
@alangilman2886 Год назад
Shane, this is a great explanation of a very spooky and mysterious feature that I've always been interested in. If we created flows and apps not in a solution, could we import them into a solution to get everything related packed into a single source? I'm assuming yes. Might be a good way to get better organized if someone isn't already using a dev > test > prod method of deploying. Thanks for covering all details so well.
@ShanesCows
@ShanesCows Год назад
Hi Alan. Yes, you can add the existing pieces into a new solution. YOu will have to rework them a bit to get them to use the Environment Variables if you want that but shouldn't be a problem, just some work. :)
@s961201
@s961201 7 месяцев назад
Super video!! Thanks for that :-) When removing current values in the environment variables - di you have to put them back in again after export? Does the same apply using pipelines?
@fadiahdab
@fadiahdab Год назад
Hi Shane, brilliant video, as usual, I like the idea of a long shot since it is more detailed , I have built all my applications in unmanaged solutions😥 because I was not aware of that before, these apps have flowes and connected to SharePoint lists, I am in process of moving one app to another Microsoft office 365 tenant how can I grab all the app pieces together? thank you
@Andy-kv2hg
@Andy-kv2hg Год назад
Really helpful content!! I have a quick question: Which environment I have to choose ( Sandbox/Production) while creating a UAT/QA/Test environment?
@a194321
@a194321 3 месяца назад
Hi Shane, when deleting all the values of the env variables in DEV before the export will the solution in DEV still work without those values pointing to the sources or do we have to re add them in (DEV) after export ? Thanks for the great video!
@gabrielfollone252
@gabrielfollone252 Год назад
Shane, I don't know if this functionality already exists, but if I need to update an environment variable in a managed solution how do I do it? Ok, I can update the information when importing for the first time but what if I want to update in a future update?
@mikelockheed8857
@mikelockheed8857 Год назад
Lovely again! I got my own Dev environment and can practice things now. I noticed when your sharepoint list is of the older (?) "Task List" - Sharepoint List type, the app does generate the environment variable for the list but if you examine the variable outside the app in the solution, it keeps saying it cannot find the list. Only the "normal" list types are in the drop down. Also I was wondering - when I'm in the app, do I see I'm using an environment variable?
@dmvogan
@dmvogan 11 месяцев назад
Shane, have you found a way to determine if a datasource is using an environment variable versus being hard-coded? In Automate, you can visually see the variable, but not in Apps. I can dig down into the JSON and find the hard-coded references, but a script would be great (if we CAN'T get a UI indication). I know, the fool-proof way is to delete ALL tables and re-add via environment variables, but a validation method would be helpful to know. I'm considering rolling my own...
@ShanesCows
@ShanesCows 11 месяцев назад
Sorry, nothing that I know of.
@mblherry
@mblherry Год назад
Thanks again for another great video Shane!! I have had a lot of issues with the SMTP connector. I get an error message "Your app was not installed correctly, missing connection reference". When I move the solution I have to edit the app within the destination environment, remove and re-add the connector, and publish. This creates an unmanaged layer over my managed app layer.
@ShanesCows
@ShanesCows Год назад
Sorry to hear that Marlon. I haven't ran into that but I also haven't used SMTP connector. I am not helpful, sorry.
@donkirkham6096
@donkirkham6096 4 месяца назад
Hey Shane, thanks for the video. I have been using solutions for a while, both manual export/import as well as using Power Platform Pipelines. I have yet to see anyone show this, but am curious if your experience is the same as mine. When I re-import the solution to upgrade recent changes, either manually or via a Pipeline, I have to remap all of the environment variable lists again. It remembers what I entered before for the Site and many other environment variable types, but not the lists. In a solution with over a dozen lists, this gets old fast. I don't know why it doesn't remember the list mapping. I know it is actually mapping via the list ID, not the name, but that ID doesn't change. All of the list mappings should be populated during the import so you can confirm or change them just like other EVs. Do you have the same experience? If so, I think I will reach out to the Power Apps Team at Microsoft and have a conversation. 😄
@MattWearmouth
@MattWearmouth Год назад
@shane - is it possible to import an existing power app and power automate flow into a new solution or do you need to build them from scratch in a solution before porting them around new solutions?
@ShanesCows
@ShanesCows Год назад
Matt you can import an existing app/flow and then edit them to use environment variables and such. I think someone else comment we also discussed if that helps.
@martinlesabe5288
@martinlesabe5288 11 месяцев назад
Hi Shane, will this approach also create environment variables automatically when using Dataverse?
@bobs8581
@bobs8581 Год назад
Really useful video Shane. I know a few people have already asked about moving an existing app into a solution. How do we go about updating the connections to be Environment Variables?
@ShanesCows
@ShanesCows Год назад
Long story, short? You have to remove the existing connections and then add them back. I guess I need to make a video on existing apps. Very common question. :)
@carlaholyk7436
@carlaholyk7436 7 месяцев назад
I was so excited to find this video BUT I'm running into an issue I'm hoping you can help me with. I want to use the environment variables to connect my flow to different lists but when I import the solution, it just overwrites my the solution I already have. In other words I'm trying to import my own solution into my environment with the same connection and it's treating it like the same solution instead of a new solution. Is there anyway to use this if I'm setting this up multiple times for different sharepoint sites and lists but always using my login (or connection)?
@McIlravyInc
@McIlravyInc Год назад
What about swapping the data sources out and using the EVs in the app? A mentor taught me to do that, so wondering of it is worthwhile or not? (Canvas apps)
@alexandrubadiu2355
@alexandrubadiu2355 Год назад
Great video Shane! Using solutions is the way to go for entreprise apps deployments. I have a question though. Sometimes the flows are not triggered anymore after migrating the solution to production. (Flows triggered by papps). It works fine on dev environment though. Have you encountered this situation before? Also, since last week, all end users need to be members of the environment in order to use the app. It was not the case before... What s your thoughts on that?
@ShanesCows
@ShanesCows Год назад
Alexandru - I am not sure. I haven't encountered that before. 😖
@chap666ish
@chap666ish Год назад
An excellent video and very timely for me as I'm just starting to use environments. One question though, you mentioned that you can move existing apps/flows into a solution - can you explain how to do that. Thanks.
@ShanesCows
@ShanesCows Год назад
In the Solution to the right of where I clicked New there is a button for Add Existing.
@chap666ish
@chap666ish Год назад
@@ShanesCows Thank you, sir!
@rohanshaw1827
@rohanshaw1827 Год назад
Love all your videos! 😁
@ShanesCows
@ShanesCows Год назад
Yay! Thank you! Love the dab. 😎
@andytuke8986
@andytuke8986 Год назад
That was every question bar one answered for my current project. What happens if I build the app and forget to click the settings to automatically create environment variables, I'll have to go and test that myself, but I'm assuming if I remove the connections, tick the box and add it back then it will be all correct
@ShanesCows
@ShanesCows Год назад
That should do it 🤗
@McIlravyInc
@McIlravyInc Год назад
I started building an app with flows and tyen tried to put into a solution and the triggers broke...does using v2 trigger prevent this or do i need to worry about it happening when I move it to it's destination environment?
@joybaylon1405
@joybaylon1405 Год назад
Hi Shane, if I need to update an existing app in prod environment do I need to import again the solution from uat environment? Will it produce different URL for the users to access the updated app?
@ShanesCows
@ShanesCows Год назад
Yes import again. no it shouldn't change the URL.
@joybaylon1405
@joybaylon1405 Год назад
@@ShanesCows thanks, Shane. Such a big help.
@clindstik
@clindstik 7 месяцев назад
Tak!
@ShanesCows
@ShanesCows 7 месяцев назад
Thank you! I appreciate the support. 🤩
@guilhermecabrera9865
@guilhermecabrera9865 Год назад
Also, in order to duplidate any sharepoint lists you can go directly to the sharepoint that you can paste your copy and start the creation there, so the option to create based on another sharepoint lists will be there.
@ShanesCows
@ShanesCows Год назад
Thanks for sharing. 😀
@aprilsuk7311
@aprilsuk7311 Год назад
Hey Shane, I'm trying to do what you told us not to do, and move an imported flow from another environment into a solution after the fact. It keeps looking for environmental variables from the last environment, even though I removed them. I even deleted the trigger and re-made it, but no avail. Am I stuck recreating the whole flow, or is there another trick I can try?
@ShanesCows
@ShanesCows Год назад
Hey April I am not sure. 😑 I haven’t done that scenario so I am no help
@aprilsuk7311
@aprilsuk7311 Год назад
@@ShanesCows it turns out it was a permissions issue. I had someone with god-access export and import the flow, and it brought the variables with it and was happy again. I now have the proper permissions to export/import myself from default. PS: You're always a help! Thank you!
@manniecobham
@manniecobham 10 месяцев назад
Hi Shane, can we use .env variables for Dataverse tables when transferring a solution from one environment to another.
@ShanesCows
@ShanesCows 10 месяцев назад
Yes, I think that is what this video shows unless I am misunderstanding the question.
@mtamitolanga
@mtamitolanga Год назад
Thanks Shane, with Power BI I'm assuming I need to create a new model connecting to my Dev or test lists?
@ShanesCows
@ShanesCows Год назад
I am not sure. I still haven't tried it. The documentation starts here if you want to give it a go. :) learn.microsoft.com/en-us/power-bi/collaborate-share/service-power-bi-powerapps-integration-about
@mtamitolanga
@mtamitolanga Год назад
@@ShanesCows the documentation confirms that you can add Power BI in your solution via Dataverse. Thank you very much Shane.
@philipmarno4989
@philipmarno4989 Год назад
Thank you very much for creating this video, it was the missing piece in the jigsaw. Please do keep in the gaff's in, great opportunity for us all to see how things can be done. May I ask: Is it possible to move an APP - developed in the Default Environment ( as I had not had the benefit of this video ) over to the Development Environment? I'd like to retrofit the ALM process on all of the APPS that are sitting live in my Default Area. I don't see an option to Import a package into a UAT Solution. Many thanks keep up the great job.
@ShanesCows
@ShanesCows Год назад
Hey Philip. You can Add Existing into your new Solution.
@philipmarno4989
@philipmarno4989 Год назад
@@ShanesCows Many thanks for the reply, Shane. I have tried this but I do not seem to be able to upload a Package taken from the Default environment into my Development Environment. I can upload to a new solution in the Default Environment so this will have to do for now. Hope this will be a feature for the future, or I'm just missing something :-)
@mtamitolanga
@mtamitolanga Год назад
Hi Shane, can I export my production environment solution (managed) to development environment (unmanaged)?. Thanks
@ShanesCows
@ShanesCows Год назад
I have never tried but I want to say yes.
@MSandovalPhD
@MSandovalPhD 11 месяцев назад
Hi Shane, thank you for the tutorial. I have a question: Can I use Environment Variables to dynamically call data sources in Power Apps? I plan to use the same app for multiple document libraries, which have identical column structures, across various SharePoint sites.
@ShanesCows
@ShanesCows 11 месяцев назад
I don't think so, you would have to add If logic to your Items of the gallery to call the different, matching lists/tables.
@yogeshm8344
@yogeshm8344 4 месяца назад
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
@ciprianfeier8306
@ciprianfeier8306 Год назад
Shane, thanks for the video, how to solve this issue? The length of the 'displayname' attribute of the 'environmentvariabledefinition' entity exceeded the maximum allowed Thanks
@ShanesCows
@ShanesCows Год назад
Yikes, I haven't had that one before so not sure. Sorry
@ciprianfeier8306
@ciprianfeier8306 Год назад
Thanks for everything you’ve done.
@mardithpascua8112
@mardithpascua8112 Год назад
Can I still on the Automatically create environment variables even if I had already connected to different dataverse table?
@ShanesCows
@ShanesCows Год назад
It will only do it for new data sources you add.
@user-me8xb1wi5g
@user-me8xb1wi5g 3 месяца назад
if it is exported as managed - Can you edit the environment variables on the destination environment at any point or only on import? (20:00)
@ShanesCows
@ShanesCows 3 месяца назад
Yes, you can change what the variables are pointed at.
@ResponsibleXI
@ResponsibleXI Год назад
Hey Shane, I have added my 3 scheduled flow with SharePoint connections into my solution and tried to add required objects. It didn't add any connections references. Do you know why?
@ResponsibleXI
@ResponsibleXI Год назад
Never mind, Shane. Flow was complaining about removing connections and add connection references on my flows. I had to do that and then add required objects pulled in the connection references. Hope other viewers can benefit.
@ShanesCows
@ShanesCows Год назад
Thanks for sharing Ramesh
@toastbutter7409
@toastbutter7409 Год назад
Great video. Do you have a video on how to add an environment Variable if you have already built an application?
@ShanesCows
@ShanesCows Год назад
I haven't made that one yet. Boo. Need to add it to the list.
@SimoneSorrentino
@SimoneSorrentino Год назад
Often with the Excel (and Word) type step, a document library in a Sharepoint Variable just do not work, breaking my flow with the error: "invalid drive". The same variable, in a Sharepoint step, goes well. What about this case? I really struggle with these, it seems like these two type of steps point to two different IDs. Any solution?
@ShanesCows
@ShanesCows Год назад
Simone I show it in this video for Excel. Sometimes you need the Identifier which is different than the ID 😑 You just have to stay on your toes and see which one it is asking for. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-QcWjAt7QVn4.html
@Amad233
@Amad233 Год назад
Hi there, I'm having an issue using SMTP connector inside my APP. It is working fine in my development environment but not in the production environment. It's as if it's looking for that connection which is in the dev environment. Even though I've set Up connection references it does not work. It is working very well for sharepoint connector though I'm sure you have used SMTP connector along with Solutions Can you please tell me how did you proceed?? Thanks 😄
@ShanesCows
@ShanesCows Год назад
I have not done SMTP in a SOlution so I am no help. Sorry.
@iamintractable1805
@iamintractable1805 Год назад
Sean, can you clarify why one would need to remove the default value from Environment variables, or change the solution in any way to export it. Won't the import prompt the user regardless in order to ensure the correct values are used in the new environment? The removed defaults have to be restored once you have export and this seems like it should be unnecessary.
@iamintractable1805
@iamintractable1805 Год назад
I have figured this out. In the video you stated that the Default value needed to be removed but you actually removed the current value. Sure wish Microsoft had implemented this differently but I suppose their thinking was that the developer would only remove the current value for those things that the import should then prompt to replace. Clunky as the import could easily be better organized to handle this by simply letting the developer decide at that time what needs to be changed. Thanks for the great video.
@swaminawale7386
@swaminawale7386 Год назад
Thanks Shane.. Really great video Just a question... I've tried this and that issue/bug is still there (data source is not being updated in new envt) Can anyone please confirm :)
@ShanesCows
@ShanesCows Год назад
Interesting. Sorry you are having problems :(
@nickthoman2280
@nickthoman2280 Год назад
Do you have a new video that shows how to handle environment variables when using Pipelines? I am running into an issue where I can't change my variables after publishing up to a TEST environment. They are greyed out.
@munkybutler1
@munkybutler1 Год назад
Hi Shane, another great video, thanks! What about importing a solution to a different tenant where it's not possible to create list from existing list. What is your recommended method for replicating the SharePoint list in that case?
@ShanesCows
@ShanesCows Год назад
Sean usually that answer is just open up two browser windows and do it by hand. Technically you can write a flow to do the conversion for you but I haven't done that on RU-vid. It is shown in my 401 class as it has a lot of moving parts.
@loveandhate441
@loveandhate441 Год назад
PnP PowerShell script - very easy --- "recommended method for replicating the SharePoint list" And the whole site with all the lists, fields, content types ....
@loveandhate441
@loveandhate441 Год назад
@@ShanesCows by hand - for not too complicated lists - yes when many fields and rows - not a good idea ((((
@GinGersound
@GinGersound Год назад
@@loveandhate441 I second this. I build all my SharePoint lists using PnP and keep the script so I can use it for my next client. It can build a site with 30 lists and hundreds of columns in minutes (while I go and make a coffee). PowerShell is your friend 😊
@ThreeDigitIQ
@ThreeDigitIQ 11 месяцев назад
How do you share environment variables? I cannot see or edit someone else environment variables, and they cannot see or edit mine. This is a huge problem when we are working together on power apps and automations.
@ShanesCows
@ShanesCows 11 месяцев назад
I am not sure, no one has ever asked that. 🤔
@DDDDDD-qi7un
@DDDDDD-qi7un 4 месяца назад
Shane quick question....First, awesome video, watching a year later haha. When you create applications for your customers do you ever create a separate environment within your tenant and then publish managed apps? For those customers who dont have the power platform and dont want to bother with getting one
@ShanesCows
@ShanesCows 4 месяца назад
We haven't done that. It would require licensing and a whole can of worms.
@cumberlandbills
@cumberlandbills 11 месяцев назад
Shane are you a fan of Skiing ? Looks like you got a nice snow tan on the go there 🙂
@ShanesCows
@ShanesCows 11 месяцев назад
Watching kids play Soccer with sun glasses on is usually where my look comes from. 😎 I have never been any good at skiing.
@rpremaza
@rpremaza 9 месяцев назад
This video made my head spin with possibilities. And questions.... I have Solution where i added a PowerBI dataset to Datasets. I want to use that dataset set in a power app. The user will selected a record from the dataset, then answer some questions and the record information and answers will be patched to SharePoint list. I can't figure out how to get may PowerApps to use the PowerBI dataset as a data source Can you point me in the right direction?
@estherlopeznavarro6100
@estherlopeznavarro6100 6 месяцев назад
I am having problems with the language of the fields, i have copied the list just like you explained but in one of the list created by and this standard field are in english and in the older list they are in norwegian, the languages of both site are the same. I cannot understand why this is happening.
@sathanreddy782
@sathanreddy782 Год назад
Is there any openings on powerapps??
@barnaliroy8703
@barnaliroy8703 Год назад
Hi, I was looking for a tutorial to do ALM with an existing app (which has over 60 flows connecting to SQL and used by over 150 users). Can you pls share how to do that?
@ShanesCows
@ShanesCows Год назад
Sorry, I don't have a video on that, it is on my list to do eventually but not soon.
@Test-oc1fr
@Test-oc1fr 9 месяцев назад
Can we create sql connection variable?
@user-me8xb1wi5g
@user-me8xb1wi5g 3 месяца назад
OK, so is any of this possible - solution with environment variables - if you cannot use dataverse? > When I made the app setting to auto create an environment variable when adding a data source - and not until saving and leaving the app and coming back into the app > settings - it shows a warning that you have to turn a dataverse setting to ON. :/ So weird that it doesn't tell you that when you first select that open or when you close the settings window.. or when you save the app. (OK done complaining).
@ShanesCows
@ShanesCows 3 месяца назад
Ugh, sorry.
@user-me8xb1wi5g
@user-me8xb1wi5g 3 месяца назад
I now have connections using the Environment variables and it required no app updates (except the data source) to all the formulas and is STANDARD license. Steps 1) Deleted existing data source connections that need to use env vars (they were pointing directly to SharePoint) (do this first so when recreating the names will be correct as referenced all over the app) 2) Added data source back (as a SharePoint connection) but when selecting the SharePoint Site use the Advanced Tab which presents you with the Environment Variables.
@side54723
@side54723 Год назад
For non admin users, they need basic role to read env variable, is that right ? Everything worked for you as you are admin ?
@ShanesCows
@ShanesCows Год назад
I believe that is correct Jeff.
@Zatiels
@Zatiels Год назад
Ive had up to 12 coworkers changing a lot of items in the same solution, on one client delivery someone published dev work in progress that broke the delivery after importing, so publishing anytime everytime isnt good.
@guyinazo
@guyinazo Год назад
I may have spoken too soon :) And hoping I will find out what I am doing wrong, but when I do deploy to QA (managed, not unmanaged) and set the Site to the QA site and the lists to the QA lists for the environment variables, for some reason the app is STILL pointing back to the DEV data lists. It is frustrating
@arunaggarwal1663
@arunaggarwal1663 Год назад
How i can change environment in power automate visual in power bi ?
@ShanesCows
@ShanesCows Год назад
I haven't done that one.
@iamintractable1805
@iamintractable1805 Год назад
Question for Discussion: I am not sure a solution should use environment variables from other solutions just because they are seen in the environment. The scope should the solution. I live in a world where the whole company is in the default environment and what a mess these variables can make. Sharing things across solutions seems like another opportunity for chaos. I am thinking of using a naming convention for things in the solution so that they can easily be identified from other solutions. Wondering how others have approached this?
@christophernicholas778
@christophernicholas778 Год назад
The part of removing the environment variable value from the solution makes no sense to me, won’t this break the existing solution?
@ShanesCows
@ShanesCows Год назад
You aren’t removing it, you are just removing it as the default. Just a weird UI. 😑
@christophernicholas778
@christophernicholas778 Год назад
Appreciate the prompt response! Thanks
@iamintractable1805
@iamintractable1805 Год назад
Question for discussion: The solution approach does not really seem well suited to SharePoint especially since the data model is not included in the solution. Most organizations don't really subscribe to the idea that staff should build multiple site instances just to support the app deployment model. In fact, the target audience for the platform will likely not even understand this approach. Low code = non-developer. How have others approached solutions?
@ShanesCows
@ShanesCows Год назад
Most people, in my experience, do not use Solutions for SharePoint based solutions. I think you are spot on.
@oysterhoys
@oysterhoys Год назад
Using environment variables makes your App ‘Premium’, so all the users need an extra license. So I if you do this, I would think it would be smarter to use Dataverse. SharePoint is especially nice if you want to keep your App free.
@ShanesCows
@ShanesCows Год назад
I don't think it makes the app premium. Why do you think that? I checked and the one I did in the video is standard still.
@janoosterhuis8864
@janoosterhuis8864 Год назад
Hi Shane, I experienced this with an App when using Env. variables. But if you say so, I will test it again. Maybe it was another premium factor in the App.
@munkybutler1
@munkybutler1 Год назад
@@ShanesCows Hi Shane, I think this does make the app premium. Using environment variables requires the use of two dataverse tables (environmentvariablevalues and environmentvariabledefinitions). This means that users of the app now need a premium power apps license because dataverse is a premium data source.
@caraziegel7652
@caraziegel7652 Год назад
at 16-ish - if you remove an environment variable and add it back in using that method . . . REMEMBER TO REMOVE DEFAULT VALUE BEFORE EXPORTING!! omg dont ask me how i know /cry
@loveandhate441
@loveandhate441 Год назад
27:32 --- Data sources are from the initial Solution. Power Automate Flows linked to this Solution - the same situation - are from the initial environment ... So, we need to DELETE All Data sources and Power Automate Flows from the new imported Solution in a new environment and then ADD the actual ones (from this current environment) Very inconvenient especially when having 40 Environment Variables and 32 Power Automate Flows and with a need to export \ import to different places. If it's a bug, when it's expected to be fixed ?
@ShanesCows
@ShanesCows Год назад
I think it is a bug that the Data panel links to the original list but the data it pulls into the app is the correct data. I have passed along to Microsoft I found this very confusing, hopeful something they will look at.
@loveandhate441
@loveandhate441 Год назад
@@ShanesCows Hi Shane, " but the data it pulls into the app is the correct data" - I don't see this when migrating solutions between different tenants (((( Thanks for pushing Microsoft !
@ShanesCows
@ShanesCows Год назад
Interesting you don't get the right stuff when you import. I will have to dig deeper. Sorry for your troubles.
@loveandhate441
@loveandhate441 Год назад
@@ShanesCows Thanks, Shane ! Really appreciated if you advise how to clone Solutions effectively Now it's a nightmare to copy a Solution like I mentioned (40 Environment Variables and 32 Power Automate Flows + App) , Dev ---> Test ---> Prod or between tenants.
Далее
Everything you need to build a Model-driven Power App
40:34
Украшаю чехлы 🎀
00:51
Просмотров 222 тыс.
Wait! Solve Delegation Easily! In Power Apps Search
29:57
Setting Up a Power Platform Environment Strategy
13:26
Power Automate Child Flow using Solution Packages
22:50
5 Power Apps Best Practices for Early Makers
13:24
Просмотров 18 тыс.
Solutions in Power Platform
9:11
Просмотров 7 тыс.