Another appreciation post, A little awhile ago i was really nothing, i got this summer part-time job where they let me experiment with power apps. I picked it up very fast, thanks to your videos and became useful to them so they decided to hire me. Now i work full time with Power Apps, Bi, Automate. Thank you Shane, i owe you my career.
Hey Shane, I wanted to take this opportunity to say thank you! I wouldn't be where I am now without you and your videos. I started working with PowerPlatform in 2020 and stumbled across your videos. In 2022 I quit my job in the industry and became a PowerPlatform consultant. In the meantime I have risen to Solution Architect. I still watch all your videos. Thanks for everything you do for the community!
Hey Shane, great video. I would expand on the ROI of Power Platform. That's what gets executives attention - I built a solution that replaces X amount of man hours per month or per year. Years ago (pre Power Platform) I was on a team that was all about automation and they were able to say "our team is able to automate X man hours per month or year" with real results/metrics. That is huge, and makes it an easy decision. Focus on how your bringing value to the business and you're already ahead of the game!
As always 💥💥 For me, its always "Why". Why does the app exist. Being able to have the conversation with the "non-technical" people and translating that into a good app is key. If you cant communicate effectively you will be on the back foot. (Unless there is a massive team and you can sit at the back and code all day 😀). Thanks Shane
Although I did not take your classes, I was able to become a citizen developer for my organization. It probably would have been much easier if I had taken them. I have found that identifying and quantifying the value - time & dollar savings / risk reductions / quality improvements - of a change (in this case, introducing a Power Platform solution) is typically the largest challenge that people face. Lots of ideas and suggestions to help individuals on this subject. As always, great job on your video.
Thanks for the video, very useful. Gave me some insight on how to "Categorize" myself relative to my skill level and current position. I'd say I'm between "Other and Hobbyist" and consultant level 2 (ish).
Hello! Do you have any video regarding multiple users in one Powerapps patching at the same time on same column? I am having issues with this. I developed an app, the final value is calculated by the areas (each area has a different gallery, and they patch their gallery accordingly). However, if they “Submit” their gallery as the same time as other user, it gets “Network error” because they both want to patch the same column. Also, if they do not Refresh the sharepont, when they submit, it will submit the value that they have rather than the one calculated at the end. I want to do something like “Refresh” and after refreshing, it “Patches” the final value.
I have a PowerApp solution from a class that I downloaded; however, how can I then make that available for a presentation? Where I work will not allow me to upload the solution into their environment. How can I get a personal PP account to upload this? I tried creating a company email to avoid this without any luck.
Hi Shane, Great video. I am a Power Platform Developer with 3+ Years of Experience. Could you please guide/suggest people like us to where to get a job in this field and where to apply. I am currently living in India but am looking for job opportunities across the globe.
Have you looked around on LinkedIn. That seems to be the most popular place for job postings. Sorry, I haven't looked for a job in a long time so I am not much help.
Shame on you Shane if you had posted this video a week before, I might land in my new job 😂 100% of the interview was what you mentioned in the last minutes 😂😂😂
Thank you so much for this very insightful video 💟 When you're ready to start hiring folks from the UK can I please be first in the queue? 🤞 And green is definitely your colour 😉
We would love to, we are slowly but surely getting things figured out. Being a small company we have to slowly stretch our bondaries. But I agree, and hopefully one day.
I'm about to take the PL-200 and would love to play in the power platform full time. I've had jobs where I was able to build automations to make work a little easier. But I haven't found a company yet to fully embrace the platform. Looking for jobs, but this video really helped putting the job search in perspective. How in depth would you say a Demo app should be? BTW, I'm a big fan!! keep up the awesome work
Your demo app should show close to the limits of what you know and is business applicable. Think about easy stuff like adding and displaying data (make it look nice and easy to use), sending emails, creating and sending PDFs, file uploads, and even parent/child relationships are all very practical things that people like to see. If you can talk to an API that is also a wow moment. 🤩
Nice Video Shane. I've been able to get through my first month in Power platform thanks to you and a few others on here. I'm looking forward to learning a lot more. Currently struggling wrapping my head around setting varibales. hehe
@@ShanesCows I'd love to see ideas on maximizing space on screens. I asked CHatGPT and it lead me to an idea about setting certain items visible based on a toggle switch. So I literally was able to double my space by combining 2 screens. Each had a form on it. I set a dual gallery screen to show each form when the gallery is selected. Genius! You could title the video, double the screen space on almost any app. ;) I bet it gets cray hits.
Hi I have one question while loading data from excel to the data verse table which contain look up column. I have two table in excel named department and employee. employee table contain reference of department id column from department table. I load data from excel to data verse table and when I tried to load data into the employee table from excel it generate an error. I load data using import from excel. like "Couldn't resolve the guid for the lookup field: cr853_dep_id." I check data as well. And when I done using power query editor data loaded but in look up column it not load the data and showing blank. Original excel file contain all the data in proper format so what to do? can you help me on that?
Oh my gosh! I can't believe I fell for clickbait!!! I happened to quickly see the headline about you in a suit and I JUST HAD TO see it! Of course, I should have known better! Six seconds in -- I'm done -- until later! Anxious to hear what you've got to say, which I know will be great! but in the meantime, I quite literally laughed out loud! Much needed!
"I dont use the fancy words" - i had one data engineer yell at me because i didnt remember what . . . i forget, alternate key? maybe? was. and then he got mad when I said the last engineer used the term 'unique identifier'. Ugg. I completely understand the concepts, but i dont always remember whatever current trendy label that concept is wearing.
Hi Shane, Thanks for the tips, it will totally help us how to start looking for a job in this kind of area. Also thanks for your training videos, currently I am in the power-up program, and they helped me much with my final app and I am also sharing your videos over the related comments 😊Especially the one with the shopping cart. And finally, totally agree with the power automate. I am not like you people, or not even level one probably, and not used many trigger & action types. (I only use the get, list, delete, update row actions) and that was enough. - Dynamic content looks cool while replying & approving, but when you use them in the functions how you write them changes, whereas to use single-double quotes is a headache. I was tired of watching videos, in the end, I created the easiest flow for them and saw that when I copy the formula and dynamic content, I can check the format and apply it to others. - Another problem with power flows is when more than 2 tables get into action, your flow is automatically adds "apply to each" s, later noticing that it is added because it may be nested in the future. But this breaks the format follow-up. (when you add dynamic content you can see from which table and which action you are getting it, but after you have added it and tried to check the format, it turns into apply to each namings. PS: If somebody knows to change the format to look like the dynamic content I will be grateful. (like below code, I can not see which table which column) sub(items('Apply_to_each')?['Column1'], items('Apply_to_each')?['Column2']) --- If we have to live with that for now , ok I can. - Testing is a problem and takes much time. - Can we create flows like functions? (I mean these connections are already that help as a low code to handle these things. But for example, you will enter the tables in order as parameters to these functions, then will check the first table for updates, will get its primary column value, check it on the other tables 3rd column, for each of the matching rows, it will send approvals, and if accepted do a, if not b...) - Backing up flows is hard or there is none, or need to back up the environment fully (I see it on googling). Some videos anyone can share will be more than great. I mixed lots of things maybe, but as a final, when a flow runs fully, that pays for everything you suffered before:)
Hi Shane, Thanks for all the informative videos. Would love to hear more about best practices of data security and some common challenges you have faced with obtaining access to client’s data for development purposes. Chris
Another appreciation post,
A little awhile ago i was really nothing, i got this summer part-time job where they let me experiment with power apps. I picked it up very fast, thanks to your videos and became useful to them so they decided to hire me.
Now i work full time with Power Apps, Bi, Automate.
Thank you Shane, i owe you my career.
Thanks for sharing! I love this and congrats on doing the hard work to get a good job. 😍
That's so cool! Congratulations on landing a job within the field! =)
Hey Shane,
I wanted to take this opportunity to say thank you! I wouldn't be where I am now without you and your videos. I started working with PowerPlatform in 2020 and stumbled across your videos. In 2022 I quit my job in the industry and became a PowerPlatform consultant. In the meantime I have risen to Solution Architect. I still watch all your videos. Thanks for everything you do for the community!
Solution architect! High five. That is very cool. 🤩
Hey Shane, great video. I would expand on the ROI of Power Platform. That's what gets executives attention - I built a solution that replaces X amount of man hours per month or per year. Years ago (pre Power Platform) I was on a team that was all about automation and they were able to say "our team is able to automate X man hours per month or year" with real results/metrics. That is huge, and makes it an easy decision. Focus on how your bringing value to the business and you're already ahead of the game!
Love it!
Thank you for addressing the topic that so many of us have been eagerly waiting for! We really appreciate it!
Happy to help. Have a great day. 🐶
As always 💥💥 For me, its always "Why". Why does the app exist. Being able to have the conversation with the "non-technical" people and translating that into a good app is key. If you cant communicate effectively you will be on the back foot. (Unless there is a massive team and you can sit at the back and code all day 😀). Thanks Shane
I like it. 😎 People skills will serve you well for sure.
Although I did not take your classes, I was able to become a citizen developer for my organization. It probably would have been much easier if I had taken them. I have found that identifying and quantifying the value - time & dollar savings / risk reductions / quality improvements - of a change (in this case, introducing a Power Platform solution) is typically the largest challenge that people face. Lots of ideas and suggestions to help individuals on this subject.
As always, great job on your video.
Thanks. Yeah, i am terrible at roi proof also. I am like duh, it is better why do we need numbers. 😂
Thank you Shane! I appreciate everything you do!
Happy to help. Have a great day. 🐶
This was great.Love the format Shane. A monthly live AMA would be a great idea to look at.
Thanks and noted 🤩
Hey Shane,
Thanks for the great tips in this video. Really appreciate all you do for the community!
Thanks for the video, very useful. Gave me some insight on how to "Categorize" myself relative to my skill level and current position. I'd say I'm between "Other and Hobbyist" and consultant level 2 (ish).
Great to hear! Maybe it will also give you some ideas of where to grow. 😎
Another good video. I do appreciate this format as well. Thank you!
Awesome, thank you!
Thank you for the tips Shane
You are welcome.
Very insightful. Thank you!
Happy to help. Have a great day. 🐶
Great video Shane and even better insight. Thanks for sharing!
My pleasure! Have a great week!
Hello! Do you have any video regarding multiple users in one Powerapps patching at the same time on same column?
I am having issues with this. I developed an app, the final value is calculated by the areas (each area has a different gallery, and they patch their gallery accordingly). However, if they “Submit” their gallery as the same time as other user, it gets “Network error” because they both want to patch the same column. Also, if they do not Refresh the sharepont, when they submit, it will submit the value that they have rather than the one calculated at the end. I want to do something like “Refresh” and after refreshing, it “Patches” the final value.
I have a PowerApp solution from a class that I downloaded; however, how can I then make that available for a presentation? Where I work will not allow me to upload the solution into their environment. How can I get a personal PP account to upload this? I tried creating a company email to avoid this without any luck.
Get a free power apps developer plan. powerapps.microsoft.com/en-us/developerplan/
Thanks for the video and the time put in!
You bet! Appreciate the view and comment 🤩
Hi Shane,
Great video.
I am a Power Platform Developer with 3+ Years of Experience.
Could you please guide/suggest people like us to where to get a job in this field and where to apply.
I am currently living in India but am looking for job opportunities across the globe.
Have you looked around on LinkedIn. That seems to be the most popular place for job postings. Sorry, I haven't looked for a job in a long time so I am not much help.
Very helpful, thank you!
Glad it was helpful! Have a good week.
👊 promo sm
Shame on you Shane if you had posted this video a week before, I might land in my new job 😂 100% of the interview was what you mentioned in the last minutes 😂😂😂
Sorry I was late, at least I was accurate. Good luck on your search.
Thank you so much for this very insightful video 💟 When you're ready to start hiring folks from the UK can I please be first in the queue? 🤞 And green is definitely your colour 😉
Thanks Wendy! I will put you at the top of the list. 🤩
Hi Shane. Isn't it high time to start hiring people from Europe as well? :D
We would love to, we are slowly but surely getting things figured out. Being a small company we have to slowly stretch our bondaries. But I agree, and hopefully one day.
Great video as always, but the suit stole the show. Looking fresh!
Thanks! I try to look my best. 😂
I'm about to take the PL-200 and would love to play in the power platform full time. I've had jobs where I was able to build automations to make work a little easier. But I haven't found a company yet to fully embrace the platform.
Looking for jobs, but this video really helped putting the job search in perspective. How in depth would you say a Demo app should be?
BTW, I'm a big fan!! keep up the awesome work
Your demo app should show close to the limits of what you know and is business applicable. Think about easy stuff like adding and displaying data (make it look nice and easy to use), sending emails, creating and sending PDFs, file uploads, and even parent/child relationships are all very practical things that people like to see. If you can talk to an API that is also a wow moment. 🤩
@@ShanesCows Thanks for the advice!
Nice Video Shane. I've been able to get through my first month in Power platform thanks to you and a few others on here. I'm looking forward to learning a lot more. Currently struggling wrapping my head around setting varibales. hehe
This should help on Variables. ruclips.net/video/mCj1X6KRYew/видео.html Enjoy the learning journye. 🤩
@@ShanesCows ❤❤😁🤯
@@ShanesCows I'd love to see ideas on maximizing space on screens. I asked CHatGPT and it lead me to an idea about setting certain items visible based on a toggle switch. So I literally was able to double my space by combining 2 screens. Each had a form on it. I set a dual gallery screen to show each form when the gallery is selected. Genius! You could title the video, double the screen space on almost any app. ;) I bet it gets cray hits.
I have an interview for a powerapps developer in 45 minutes and here I am! Wish me luck Shane :D
LUCK! You got this. 😎
Bro... that suit, ha ha ha.
I knew you would love it. 😍
Hi I have one question while loading data from excel to the data verse table which contain look up column. I have two table in excel named department and employee. employee table contain reference of department id column from department table. I load data from excel to data verse table and when I tried to load data into the employee table from excel it generate an error. I load data using import from excel. like "Couldn't resolve the guid for the lookup field: cr853_dep_id."
I check data as well. And when I done using power query editor data loaded but in look up column it not load the data and showing blank. Original excel file contain all the data in proper format so what to do? can you help me on that?
Oh my gosh! I can't believe I fell for clickbait!!! I happened to quickly see the headline about you in a suit and I JUST HAD TO see it! Of course, I should have known better! Six seconds in -- I'm done -- until later! Anxious to hear what you've got to say, which I know will be great! but in the meantime, I quite literally laughed out loud! Much needed!
Glad to help brighten your day. I couldn't even imagine trying to do THE WHOLE video in a suit. I might have died. 😹
Great video! You brought up many good points, especially the Demo App! Thanks for sharing!
Glad it was helpful! I have interviewed a lot of people, hopefully this helps everyone get the job they want.
"I dont use the fancy words" - i had one data engineer yell at me because i didnt remember what . . . i forget, alternate key? maybe? was. and then he got mad when I said the last engineer used the term 'unique identifier'. Ugg. I completely understand the concepts, but i dont always remember whatever current trendy label that concept is wearing.
I'll have to figure out how to do a personal sample app. I've only done it in work settings where i dont have to go find licenses and such
Yeah fancy words are for the birds in my book. Either you know it or you don’t.
Very informative video. Thank you!
Glad it was helpful!
Hi Shane,
Thanks for the tips, it will totally help us how to start looking for a job in this kind of area.
Also thanks for your training videos, currently I am in the power-up program, and they helped me much with my final app and I am also sharing your videos over the related comments 😊Especially the one with the shopping cart.
And finally, totally agree with the power automate. I am not like you people, or not even level one probably, and not used many trigger & action types. (I only use the get, list, delete, update row actions) and that was enough.
- Dynamic content looks cool while replying & approving, but when you use them in the functions how you write them changes, whereas to use single-double quotes is a headache. I was tired of watching videos, in the end, I created the easiest flow for them and saw that when I copy the formula and dynamic content, I can check the format and apply it to others.
- Another problem with power flows is when more than 2 tables get into action, your flow is automatically adds "apply to each" s, later noticing that it is added because it may be nested in the future. But this breaks the format follow-up. (when you add dynamic content you can see from which table and which action you are getting it, but after you have added it and tried to check the format, it turns into apply to each namings. PS: If somebody knows to change the format to look like the dynamic content I will be grateful. (like below code, I can not see which table which column)
sub(items('Apply_to_each')?['Column1'], items('Apply_to_each')?['Column2']) --- If we have to live with that for now , ok I can.
- Testing is a problem and takes much time.
- Can we create flows like functions? (I mean these connections are already that help as a low code to handle these things. But for example, you will enter the tables in order as parameters to these functions, then will check the first table for updates, will get its primary column value, check it on the other tables 3rd column, for each of the matching rows, it will send approvals, and if accepted do a, if not b...)
- Backing up flows is hard or there is none, or need to back up the environment fully (I see it on googling). Some videos anyone can share will be more than great.
I mixed lots of things maybe, but as a final, when a flow runs fully, that pays for everything you suffered before:)
Hi Shane,
Thanks for all the informative videos. Would love to hear more about best practices of data security and some common challenges you have faced with obtaining access to client’s data for development purposes.
Chris
Thanks for tips! Another great video, looking forward to getting into this field!!
As I am currently looking for work, this was super helpful. Thank you!
Glad it was helpful! I hope you find an awesome job!