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!

- 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

[cotterdev]

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!

[theodoraclark]

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! <3

[fatemahalawadhi]

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

[lstgeorge]

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

[RJbob]

Great video. Please could you share how to do this but adding data to a new excel sheet that generated each time the power app is used? Perhaps using automate flows for this?

[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.

[wzcwhee]

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

[wzcwhee]

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

[deliyanehete]

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

[krishnaaveersinghhada]

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

[rossmarvin]

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

[krishnaaveersinghhada]

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

[michaeldell]

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

[kittydoes]

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

[Goenie]

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

[FernandoHunth]

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

[vikingg]

This lady should do the PowerApps tutorials!