Rocking video, I have just stated my Power Apps journey. This will take my power apps to the next level. I look forward to watching and using all of the future videos for the Hidden Gems series as this will set me aside the few other developers in the company that are using Power Apps. You rock. And thanks for the quick video of the items. It is great to get a short video that contains direct information where you don't have to view a 2 hour video for a 15 min section that applies t my needs. Great video format, sound and examples. Goadzilla
Thanks for compliment M. Depending on the topic some of my videos can go up to an hour, however, those are still broken down into sections and focus on building a full solution. However, I tend to keep my videos inside 30 minutes.
Hi Paul, Glad you are benefiting from the video and let me know if there are other PowerApps topics you'd like me to blog about. Make sure you subscribe and let others know about it as well.
Hi Daniel, yet another question, on template fill can we use ThisItem.value? For ex:If(ThisItem.Value = 4,RGBA(204, 204, 204,0),RGBA(0,0,0,0)) My gallery Item property is sequence(7,0). I want to color first row and last two row in grey or disable those row
Hi Daniel, really appreciate. By any chance have you did any video for textbox validation in powerapps.. Users can enter only numbers, dot,comma Rest all can't enter And pre-comm, post comma, and consecutive comma or dot not allowed.. Help us since this is very basic thing whic is everyone required.
Hi Kmurali, Thanks for the compliment and you are most welcome. I do not have any videos that cover those topics, however, I will add them to my to-do list 😀. For the numbers only, add the text control and look at the advanced properties. You will see the option for numbers only,
I had problem connecting to an Excel file in OneDrive Business. When I choose that as my data source for the gallery, it just goes blank. But when I connect it to the form, it's fine. Wonder what the problem is?
Hi Chilololo, The PowerApps gallery does show data from Excel in a gallery as long as it sits in OneDrive. Maybe you don't have all the controls in your gallery that match the data coming from Excel?
Daniel, really great stuff! Just a bit of clarification on #4, though. That dialog you see when closing the browser tab or window is a default behavior in Chrome. If you're on a page with something it recognizes as form fields, it warns you that you might lose data. The "Confirm Exit" feature (which I wasn't aware of until this video) and its corresponding message only appears when you have a control in the app that triggers an "exit" of the app. For example, I have an app faculty use to enter attendance info to which I added a "log out" button to mimic the same control in our LMS.
Hi Chad, Take a look at the video again from 15:00 onwards and you'll see that I don't get a dialogue message when I FIRST close the tab as a test. However, after I make the ConfirmExit=True, the message comes up. Try it!
@@DanielChristian19 OK, I'll concede that the "Leave Site?" dialog doesn't appear until you set "ConfirmExit" to true, but the "ConfirmExitMessage" text only appears if you initiate the exit/close from within the App. See th-cam.com/video/8BNaMKM1WEM/w-d-xo.html
Another great video from you and some of these I did not know about like the transition.Pop. Sadly, here at my job, we are going back to using windows forms apps instead of Power Apps and from what I understand, it is because of the new licensing model for Power Apps. We have several hundred E1 and E3 licenses, but management found out that Microsoft now wants to start charging $7 more per user per month if someone is to use or consume power apps. We have end users who might access a power app once a year, but they need to pay this fee? And I found out it is because we use on-prem SQL as a back end database. would you know? If this is true then it would be upward of around $100K per year extra just for an end user to get into a power app every so often.
Thanks Brad, for the compliment. PowerApps is included in E1 and E3, however, if you plan to use on-premises gateway then you will need PowerApps P1 as well. For more information you can look at the licensing overview page --> docs.microsoft.com/en-us/power-platform/admin/pricing-billing-skus#powerapps-for-office-365
@@DanielChristian19 And I believe licensing is per user, not per seat, correct? Because like I said in our situation, the users would only be using some power apps maybe once a year and the P1 cost is $7 per user per month. I wish I could talk management into using azure sql.
Rocking video, I have just stated my Power Apps journey. This will take my power apps to the next level. I look forward to watching and using all of the future videos for the Hidden Gems series as this will set me aside the few other developers in the company that are using Power Apps.
You rock. And thanks for the quick video of the items. It is great to get a short video that contains direct information where you don't have to view a 2 hour video for a 15 min section that applies t my needs. Great video format, sound and examples.
Goadzilla
Thanks for compliment M.
Depending on the topic some of my videos can go up to an hour, however, those are still broken down into sections and focus on building a full solution. However, I tend to keep my videos inside 30 minutes.
I really like your video topics and teaching style. Keep the videos coming. Liked & Subscribed!
That is a huge compliment. Thanks Brandon!
Hey Dan, awesome video. Glad I viewed it and learned some valuable information from it. Good work as always. Thank you for sharing.
You are most welcome dhawallseth
Awesome! The UI side of template fill and pop push will be very helpful. Keep Going! :)
Your welcome Jayboy Bags!
Do you see any hidden PowerApps features? Let me know and I'll shout out your name, twitter handle in my blog!
Awesome video. Really love the Hidden Gems idea and hope that becomes a series that continues!
I plan on it. Do you see any hidden PowerApps features? Let me know and I'll shout out your name, twitter handle in my blog!
I'm glad I stumbled on your video! ALREADY updating my apps. Great find.
Hi Paul,
Glad you are benefiting from the video and let me know if there are other PowerApps topics you'd like me to blog about. Make sure you subscribe and let others know about it as well.
Excellent work sir.Loved all the gems
You are most welcome and I have more of this videos in the works.
Hi Daniel,
yet another question,
on template fill can we use ThisItem.value? For ex:If(ThisItem.Value = 4,RGBA(204, 204, 204,0),RGBA(0,0,0,0))
My gallery Item property is sequence(7,0). I want to color first row and last two row in grey or disable those row
Hi Papitha,
I haven't tried that yet but it sounds doable. There's only one way to find out 😉
Thanks for the really awesome serie!
Thanks for the compliment Rob.
Loads of information. Really very good video. Thanks for sharing.
You are most welcom Danish.
Hi Daniel, really appreciate.
By any chance have you did any video for textbox validation in powerapps..
Users can enter only numbers, dot,comma
Rest all can't enter
And pre-comm, post comma, and consecutive comma or dot not allowed..
Help us since this is very basic thing whic is everyone required.
Hi Kmurali,
Thanks for the compliment and you are most welcome. I do not have any videos that cover those topics, however, I will add them to my to-do list 😀. For the numbers only, add the text control and look at the advanced properties. You will see the option for numbers only,
@@DanielChristian19 I tried but how to prevent all the symbol other than only comma and dot ..?help me
I’ve been looking for something similar that would limit the amount of characters
I had problem connecting to an Excel file in OneDrive Business. When I choose that as my data source for the gallery, it just goes blank. But when I connect it to the form, it's fine. Wonder what the problem is?
Hi Chilololo,
The PowerApps gallery does show data from Excel in a gallery as long as it sits in OneDrive. Maybe you don't have all the controls in your gallery that match the data coming from Excel?
Very helpful for a power apps noob like me
Hi! Where can I get this Demo Spreadsheet ???
Hi Ricardo,
You can find that and other juicy PowerApps content here --> powerapps.microsoft.com/en-us/blog/power-platform-challenges/
Daniel, really great stuff! Just a bit of clarification on #4, though. That dialog you see when closing the browser tab or window is a default behavior in Chrome. If you're on a page with something it recognizes as form fields, it warns you that you might lose data. The "Confirm Exit" feature (which I wasn't aware of until this video) and its corresponding message only appears when you have a control in the app that triggers an "exit" of the app. For example, I have an app faculty use to enter attendance info to which I added a "log out" button to mimic the same control in our LMS.
Hi Chad,
Take a look at the video again from 15:00 onwards and you'll see that I don't get a dialogue message when I FIRST close the tab as a test. However, after I make the ConfirmExit=True, the message comes up. Try it!
@@DanielChristian19 OK, I'll concede that the "Leave Site?" dialog doesn't appear until you set "ConfirmExit" to true, but the "ConfirmExitMessage" text only appears if you initiate the exit/close from within the App. See th-cam.com/video/8BNaMKM1WEM/w-d-xo.html
Nice...keep it coming
You got it. I've started planning for my #3 video. Let me know if you have any suggestions.
Awesome!! Thank you very much
Your welcome Lisa!
Very nice tricks.
Thanks Echico!
Another great video from you and some of these I did not know about like the transition.Pop. Sadly, here at my job, we are going back to using windows forms apps instead of Power Apps and from what I understand, it is because of the new licensing model for Power Apps. We have several hundred E1 and E3 licenses, but management found out that Microsoft now wants to start charging $7 more per user per month if someone is to use or consume power apps. We have end users who might access a power app once a year, but they need to pay this fee? And I found out it is because we use on-prem SQL as a back end database. would you know? If this is true then it would be upward of around $100K per year extra just for an end user to get into a power app every so often.
Thanks Brad, for the compliment.
PowerApps is included in E1 and E3, however, if you plan to use on-premises gateway then you will need PowerApps P1 as well. For more information you can look at the licensing overview page --> docs.microsoft.com/en-us/power-platform/admin/pricing-billing-skus#powerapps-for-office-365
@@DanielChristian19Thanks I will check it out
@@DanielChristian19 And I believe licensing is per user, not per seat, correct? Because like I said in our situation, the users would only be using some power apps maybe once a year and the P1 cost is $7 per user per month. I wish I could talk management into using azure sql.
That is correct, it is per user.