Turns out I was way sick with Covid when I sat through their (virtual) training the first time. I'm so delighted they make this information available for later reference.
So grateful for all your dedication and community support, thank you Brian and the team. It's really a blessing to find such a real scenario and well detailed explained video for free, nice explanation and perfect for us newbies , helps as a foundation for learners..which is difficult to find online, most vloggers tend to provide very advanced contents all the time on top of that their explanation isn't intermediate/beginner focused
Thank you so much for this video! I've been wanting to build some apps for work and was going to head down the HTML, CSS, JS or Python route, but this has me excited to explore PowerApps further first.
Hello! Amazing video! I am trying to create sort of a knowledge base for my team at work, but my info or data source comes from OneNote and Teams (a private channel I created), it includes links, PDFs, excel files and I would LOVE for my team to see all this info like an app so that only one person can edit the information and the rest and see it and access it. Is PowerApps the best option to do this? I would love to. Thank you!
Thanks for the video. Very helpful. A quick question. Is it possible to drag field across the canvas? Something like spacing the fields by dragging them vertically.
Good day, how do i activate the little icon or edit field as mine does'nt give me that option after adding table for DataSource on the right side of the screen
Thanks for the tutorial! I am starting and it's being very useful. However, how do you select, from the form, which kin of entry do you want for each field? In my case they all come up as text "ABC", I saw you had date, calendar, yes/no buttons... Thanks in advance!
If you have set an edit form's field to not be visible, e.g. create inspection | parkId field, how do you later access that field again if you want to set visibility back to on, e.g. for debugging purposes? When i visit the edit form's | fields view i see "ParkID (custom)" and clicking the expand/collapse chevron it doesn't present me with details about the field i originally saw when changing visible on -> off.
First of all, I'm a total newb to Power Apps. One thing I noticed when using the Inspection app is that if you choose to Edit the inspection, then Cancel, then press New to do a new inspection it retains the data from the inspection edit that was cancelled. This doesn't happen when using Alt within the program edit like you did in the video. I added NewForm(Form1); in front of Back() on the OnSelect code for the Cancel button and it fixed the problem. I think I could have done it at the beginning of the code for the New button, too. Is there a problem/preference with either of those solutions?
Hi @Jason, you can place this in any order but I would have normally put it into the OnSuccess event instead of where we put it in this video for demonstration purposes. THe NewFOrm function resets the form back to newform mode but if you cancelled, your data will still be there. The way around that is to do a ResetForm when you click Cancel
Is the only way to share it through a web interface ? Can you make it show up in office.com in top left with the circles buttom where word, excel, powerpoint online reside ?
Hi , very well versed description and very good video. I have one query on Power APP. How to create Power APP using Power APP Dataflow as source. What is the significance of dataflow which is build on "Do not load" on Entity mapping while creating Dataflow. Thanks Amit
@@PragmaticWorks it means, if I created dataflow with "Do not load" then it will only create schema and doesn't hold any data and cannot be used as a source for app.? Secondly, how to use power app dataflow ( if entity created) as a source for app ( power app)?
When I add NewForm(Form1) and Back () in Save button, it looks like that PowerApps doesn't realize NewForm function and it informs about the semicolon error ( ; ). Does anyone else have the same problem? :(((
Hello GE How to filter sharepoint birthday list by todays date in powerapps screen my sharepoint name is birthday : name | DOB | birthday days & Months i had used powerapps filter(sharepoint list name source file , birthday day & months =today()) but dosent display todays list in powerapps can you help (formula)
Is there a way to diff the changes between two versions? Is there a way to export app for review by person without access to your environment, e.g. export from your environment that they can import into their environment to peruse implementation and provide feedback?
I'm writing one for Apress right now. We have a boatload of guided learning classes at www.pragmaticworks.com then click Training. That has a free App in a Day class as part of that on demand learning.
Thank you for publishing the video regarding the Park Inspection App as an example. However I have a problem - I see all inspections in each park and this is not desired behavior. How to involve a filter to display just the corresponding inspections matching the parkID? Did I do some mistake or did I miss something? I didn’t find the answer in the video.
How can I retrieve data in Power Apps from a SharePoint list based on source list item ID? What I want to do is have fields like FormID1, FormID2, FormID3, etc. in my Power App solution, and be able to retrieve combinations of item detail from any connected lists on load, using source list ID numbers provided by Power Automate. How can I do this with Power Apps?
Hello! Thank you very much for the tutorial - it helped me a lot! But there's one issue: each time I put a semicolon, it underlines with red and refuses to read the next line I have written. I have also tried to substitute it with the simple coma but it doesn't work either. Can I fix it?
Are you in Europe? If(ThisItem.Price>1000,OrangeRed,Gray) or for alternate/European locales: If(ThisItem.Price>1000;OrangeRed;Gray). You can end the semicolon in EU with a double ;;
It sure would. Unfortunately, this is a beginner video to get people started. We have other videos in the playlist though that cover components and responsive apps.
Thank you for sharing this video, its very helpful. Am getting following error while adding the filter on scrInspections: Formula: Filter('[dbo].[Inspection]',ParkID=galBrowseParks.Selected.ParkID) Error: "Filter expression must evaluate to a single boolean value" Please help, its urgent
OK That's the code for sure so it's likely something else. One thing to try before debugging is to Save the app, close it and open it again to see if it's just evaluating things inappropriately. -- Brian
Sure, that warning means that the form is in Edit mode instead of New mode. So, click on the form, and change the Form MOde (Default MOde) from Edit to New. You might have to flip back and forth to make it fly.
Sounds like no one has given you permissions to the company environment. You can create a personal environment by going here: powerapps.microsoft.com/en-us/communityplan/ and selecting Create Individual Environment. It will take you back to Power Apps and click Refresh after 10 secs or so to see your personal environment. - Brian
Turns out I was way sick with Covid when I sat through their (virtual) training the first time. I'm so delighted they make this information available for later reference.
Excellent introduction to Power Apps. Thank you for putting this together. Best use of my 40 minutes today :)
Glad it was helpful!
So grateful for all your dedication and community support, thank you Brian and the team. It's really a blessing to find such a real scenario and well detailed explained video for free, nice explanation and perfect for us newbies , helps as a foundation for learners..which is difficult to find online, most vloggers tend to provide very advanced contents all the time on top of that their explanation isn't intermediate/beginner focused
Thanks so much. You rock. - Brian
I'm starting in Power Apps, and this was really helpful!! thank you!
Glad it was helpful!
Same here. Its like Access, just for the future and better for SP and Teams :)
Anxious for others videos like this. Thank you for sharing. Won my like !!!
Awesome, thank you! We already have a bunch of series like this you can find ono our channel based on what you're looking for. Thanks!
Just started working with Power Apps and your videos made life so much easier! Thank you!
Happy to help! - Brian
This was an excellent demonstration for any new user of Power Apps - highly recommended!
Glad it helped!
This is the most complete first start, thank you so much!
Glad it helped!
You rock!!!
Excellent video!
Thanks again!
Thank you so much for this video! I've been wanting to build some apps for work and was going to head down the HTML, CSS, JS or Python route, but this has me excited to explore PowerApps further first.
You bet @Jason! - Brian
Thanks for sharing! 👍
This video was very useful to understand. Thanks.
Glad it was helpful!
Thank you so much.... Leaning new things everyday!
Thank you for your help !
You are good explaining ,real clear.
Hello! Amazing video! I am trying to create sort of a knowledge base for my team at work, but my info or data source comes from OneNote and Teams (a private channel I created), it includes links, PDFs, excel files and I would LOVE for my team to see all this info like an app so that only one person can edit the information and the rest and see it and access it. Is PowerApps the best option to do this? I would love to. Thank you!
Your videos are great! Big thanks!
You are welcome!
Thank you so much
Great Lesson to Learn Power Apps, very helpful, Thanks a lot.
dude you remind me of the dealer from Were The Millers and the dentist from The Hangover. I love watching your vids x)
LOL. Not sure if that's a good thing.
@@PragmaticWorks Haha definitely!!
Thank you for these videos!
Thanks for the video. Very helpful.
A quick question. Is it possible to drag field across the canvas? Something like spacing the fields by dragging them vertically.
Good day, how do i activate the little icon or edit field as mine does'nt give me that option after adding table for DataSource on the right side of the screen
You can unselect the gallery and reselect the entire gallery again typically. Alternatively, just select the data source on the right pane.
Great! Can you share an specific inspection with others? So they only can se items that belongs to them? Thanks
Sure, you just have to model the database accordingly to support it.
With the images for the Park, where did save these photos? do you upload them into library in the cloud?
I've already uploaded them to the cloud to simplify the example.
Thanks for the tutorial! I am starting and it's being very useful. However, how do you select, from the form, which kin of entry do you want for each field? In my case they all come up as text "ABC", I saw you had date, calendar, yes/no buttons...
Thanks in advance!
If you have set an edit form's field to not be visible, e.g. create inspection | parkId field, how do you later access that field again if you want to set visibility back to on, e.g. for debugging purposes? When i visit the edit form's | fields view i see "ParkID (custom)" and clicking the expand/collapse chevron it doesn't present me with details about the field i originally saw when changing visible on -> off.
Thank you for this informative session. We need PowerApps Portal tutorial , any recommendations?
I'm about to start a series on that as well. I have 5 or so videos and they start here: th-cam.com/video/2EXSdJw1TEY/w-d-xo.html
@@PragmaticWorks Thank you
is there a free sign up available for personal learning?
First of all, I'm a total newb to Power Apps. One thing I noticed when using the Inspection app is that if you choose to Edit the inspection, then Cancel, then press New to do a new inspection it retains the data from the inspection edit that was cancelled. This doesn't happen when using Alt within the program edit like you did in the video. I added NewForm(Form1); in front of Back() on the OnSelect code for the Cancel button and it fixed the problem. I think I could have done it at the beginning of the code for the New button, too. Is there a problem/preference with either of those solutions?
Hi @Jason, you can place this in any order but I would have normally put it into the OnSuccess event instead of where we put it in this video for demonstration purposes. THe NewFOrm function resets the form back to newform mode but if you cancelled, your data will still be there. The way around that is to do a ResetForm when you click Cancel
i liked but haven't used but plan to do so
Is the only way to share it through a web interface ? Can you make it show up in office.com in top left with the circles buttom where word, excel, powerpoint online reside ?
You can make it show up in Teams and also in a company internal store (Dynamics)
Do I need to have a work/school email to sign up for a community edition of the Power App?
Hi , very well versed description and very good video.
I have one query on Power APP.
How to create Power APP using Power APP Dataflow as source.
What is the significance of dataflow which is build on "Do not load" on Entity mapping while creating Dataflow.
Thanks
Amit
You can delay the load to happen at a different time or just create the schema if you wanted.
@@PragmaticWorks it means, if I created dataflow with "Do not load" then it will only create schema and doesn't hold any data and cannot be used as a source for app.?
Secondly, how to use power app dataflow ( if entity created) as a source for app ( power app)?
Nice work 👏
Thanks ✌️
When I add NewForm(Form1) and Back () in Save button, it looks like that PowerApps doesn't realize NewForm function and it informs about the semicolon error ( ; ). Does anyone else have the same problem? :(((
Hello GE
How to filter sharepoint birthday list by todays date in powerapps screen
my sharepoint name is birthday : name | DOB | birthday days & Months i had used powerapps
filter(sharepoint list name source file , birthday day & months =today()) but dosent display todays list in powerapps can you help (formula)
Is there a way to diff the changes between two versions? Is there a way to export app for review by person without access to your environment, e.g. export from your environment that they can import into their environment to peruse implementation and provide feedback?
Brian, any Power Apps books or other guided learning for Power Apps you'd recommend?
I'm writing one for Apress right now. We have a boatload of guided learning classes at www.pragmaticworks.com then click Training. That has a free App in a Day class as part of that on demand learning.
@@PragmaticWorks Awesome! I've checked out a few of your videos and your content is super helpful for someone just picking this up.
nice content!
Thank you for publishing the video regarding the Park Inspection App as an example. However I have a problem - I see all inspections in each park and this is not desired behavior.
How to involve a filter to display just the corresponding inspections matching the parkID? Did I do some mistake or did I miss something?
I didn’t find the answer in the video.
Question self-answered :)
How can I retrieve data in Power Apps from a SharePoint list based on source list item ID?
What I want to do is have fields like FormID1, FormID2, FormID3, etc. in my Power App solution, and be able to retrieve combinations of item detail from any connected lists on load, using source list ID numbers provided by Power Automate.
How can I do this with Power Apps?
Hello! Thank you very much for the tutorial - it helped me a lot! But there's one issue: each time I put a semicolon, it underlines with red and refuses to read the next line I have written. I have also tried to substitute it with the simple coma but it doesn't work either. Can I fix it?
Are you in Europe?
If(ThisItem.Price>1000,OrangeRed,Gray) or for alternate/European locales: If(ThisItem.Price>1000;OrangeRed;Gray). You can end the semicolon in EU with a double ;;
@@PragmaticWorks Yes, I am in Europe. Thanks a lot, it worked!
It would be efficient to use Components, at least for the header. Also, responsive design would be great.
It sure would. Unfortunately, this is a beginner video to get people started. We have other videos in the playlist though that cover components and responsive apps.
Does this database connection still work? I cannot get it to work...
Yes it does. The biggest issue that people might do is not scroll down, be logged in with VPN or mistype something.
Thank you for sharing this video, its very helpful.
Am getting following error while adding the filter on scrInspections:
Formula: Filter('[dbo].[Inspection]',ParkID=galBrowseParks.Selected.ParkID)
Error: "Filter expression must evaluate to a single boolean value"
Please help, its urgent
This got resolved on its own, while the tool is showing the error but when i run i am able to see the change, sluggish IDE i must say
OK That's the code for sure so it's likely something else. One thing to try before debugging is to Save the app, close it and open it again to see if it's just evaluating things inappropriately. -- Brian
how can you add confirmation dialog when deleting item?
You can see how to dialog boxes here: th-cam.com/video/SaDEVOgOlYY/w-d-xo.html&
perfect
When i click New or Edit i get "No Item to display" with a blank page
Sure, that warning means that the form is in Edit mode instead of New mode. So, click on the form, and change the Form MOde (Default MOde) from Edit to New. You might have to flip back and forth to make it fly.
👍
I have no environments in my portal. I thought this was for beginners? :)
Sounds like no one has given you permissions to the company environment. You can create a personal environment by going here: powerapps.microsoft.com/en-us/communityplan/ and selecting Create Individual Environment. It will take you back to Power Apps and click Refresh after 10 secs or so to see your personal environment. - Brian