How to Connect Power Apps to an Excel Spreadsheet - Beginner Tutorial

Power Apps Excel: Would you like to build your first PowerApps app? This is a great place to start. We'll take a spreadsheet and build a view and edit screen out of it! These are great first steps as you begin your journey learning PowerApps. We'll use a form / formulas, a gallery, and a spreadsheet!
➡️ Get access to our free Power Apps crash course (and our community) here: go.superpowerlabs.co/superlan...
- Darren Neese, Microsoft MVP, PowerApps Tutorial
TIMESTAMPS =======================================
0:00 - Intro with Nicole
0:34 - Creating the new app and naming it
1:35 - Creating a new screen and thinking about your data
2:46 - Adding Excel spreadsheet as a data source
5:00 - Adding controls to our screen
9:49 - Adding the form to the screen
14:25 - Tying the form to the selected item in the gallery
15:45 - Running your application with F5 or the play button
16:25 - Adding the save button
17:15 - Adding the SubmitForm function
18:57 - Adding new records by using NewForm
20:53 - Shortcut to run the app by using the alt key
21:16 - Deleing records by using the Remove function
22:50 - Using the ThisItem operator keyword
23:40 - Hiding repetitive controls in the gallery by using visible property
24:40 - Tips and tricks I use in my other apps
24:55 - TemplateFill property of a gallery and using IsSelected
27:05 - Adding in row separators in the gallery
27:50 - Changing TemplatePadding
28:18 - Moving our controls to a better screen
29:38 - Sizing controls
30:18 - Save early, save often, and auto save
31:06 - Fixing the colors and making everything look right
31:43 - Message from Nicole
#DarrenNeese
#PowerAppsTutorial
#LowCode

[@PowerAppsTutorial]

🍬 Get my free video course, access to my free community, and, if you would like, you can book a call with me here: go.superpowerlabs.co/opt-in-page-page ⬅

[@theodoraclark5111]

Had no luck with many MANY youtube tutorials until I came across this one, really simple and easy to follow, I like the fact that he explains what you might be seeing even if it's different from what is on his screen. Thank you!

[@PowerAppsTutorial]

Great feedback... thanks alot😊😃

[@cotterdev3312]

Not new to programming, but I'm just starting out with powerapps. I watched two other tutorials and didn't get a whole lot out of them. I watched this tutorial and it had everything I was looking for. Great simple explanations and we were on our way to building an app. Absolutely loved this video! Great work!

[@PowerAppsTutorial]

Thank you so much! That made my day!

[@fatemahalawadhi5961]

Honestly I absolutely like everything about this video, excellent delivery.. Thank you!!

[@PowerAppsTutorial]

Glad you enjoyed it!

[@lstgeorge7370]

You are the best tutor i have meet, thank you so much for sharing your knowladge. :)>

[@PowerAppsTutorial]

Wow, thank you so much for the kind words!

[@pandukawb]

This is amazing! Thank you

[@PowerAppsTutorial]

You're welcome!! 😀👍

[@st-wq3kj]

Great tutorial

[@PowerAppsTutorial]

Glad you think so!

[@mahfoudhbinsabbah6719]

very good video thanks

[@PowerAppsTutorial]

Glad you liked it! Thanks so much!

[@jkc6144]

💯💯

[@PowerAppsTutorial]

Glad it was helpful 😊

[@user-wz6cw4he1e]

Hey! Great tutorial. Does the changes/new additions in the app automatically update your excel data source?

[@PowerAppsTutorial]

Yes it does

[@maliffi]

Fantastic Video! Is there a way to have a popup come up to make sure you really wanted to delete something? I envision an end user hitting it on accident and we don't realize it for several months.

[@PowerAppsTutorial]

Sure! I cover popup windows here: kzbin.info/www/bejne/e5jPY4d6n5Wam5Y and another one here: kzbin.info/www/bejne/hpmQd4Nsd82jg5Y

[@user-wz6cw4he1e]

Hi! Great Tutorial. Does the edits/additions generated in the app automatically update the data source ie excel spreadsheet?

[@PowerAppsTutorial]

Yes it does

[@rossmarvin6078]

Great video. One thing that I can't get working is opening the table in the form. Any ideas? Opens in the gallery but nothing in the form

[@rossmarvin6078]

Found it. Need to upload it directly from one drive through the connectors menu

[@PowerAppsTutorial]

Very good!! Thanks for commenting and letting me know you got it resolved! :)

[@Goenie2005]

Great video again, but actually we didn't see how the button greyed out, because your screen share was blocking it. 😅

[@PowerAppsTutorial]

Sorry about that. 😥

[@krishnaaveersinghhada9220]

Can you please show how to integrate SharePoint and Outlook? I have to automate the process of auto follow up on some tickets,,

[@PowerAppsTutorial]

Thanks for the input! I'll have to add that to my list of future videos. Can you tell me more about it? Do tickets come through as emails? ...and you need to add records to a SharePoint list as those emails come in, or what exactly is the scenario? Thanks!

[@krishnaaveersinghhada9220]

@@PowerAppsTutorial yes this is the same, it should be added to SharePoint, and it should send reminders to team to pick the request,,

[@krishnaaveersinghhada9220]

If multiple user add the new entry, will it allow to add in Excel sheet in different rows

[@PowerAppsTutorial]

Thanks for the question! Yes, but if you would like multiple people to use your application, you will want to move the data over to SharePoint. SharePoint works much better as a data source over Excel.

[@deliyanehete8811]

Hi. If we apply filter on gallery and try to add new records in the gallery,it is not showing,but it updated in the database

[@PowerAppsTutorial]

Post your questions to our free community here for quick help: www.skool.com/power-apps-community

[@kittydoes7600]

Would this also work if the excel file is in a Sharepoint folder?

[@PowerAppsTutorial]

Definitely, try it out!😀

[@kittydoes7600]

@@PowerAppsTutorial it did work! Thank you so much!!!

[@michaeldell6309]

Hey, I'm trying to do this, which has the excel data update due to powerapps I'd But, I am also using custom table due to having drop down tabs etc which doesn't connect to the Excell Do you have a solution Thank you

[@PowerAppsTutorial]

Post your questions to our free community here for quick help: www.skool.com/power-apps-community

[@vikingg97]

This lady should do the PowerApps tutorials!

[@PowerAppsTutorial]

Thanks! I'll let her know you said so!

[@FernandoHunth]

Excel datasource is a mess, I can't see all my columns

[@PowerAppsTutorial]

Excel is difficult to master. It is a whole world.