How to Connect Power Apps to an Excel Spreadsheet

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

Рет қаралды 39,957

Күн бұрын

Пікірлер: 46

@PowerAppsTutorial 2 жыл бұрын

🍬 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 ⬅

@cotterdev3312 2 жыл бұрын

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 2 жыл бұрын

Thank you so much! That made my day!

@theodoraclark5111 2 ай бұрын

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 2 ай бұрын

Great feedback... thanks alot😊😃

@fatemahalawadhi5961 Жыл бұрын

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

@PowerAppsTutorial 10 ай бұрын

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!

@RJ85bob Ай бұрын

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?

@PowerAppsTutorial Ай бұрын

Great suggestion! Post your question on my FREE community for quick help: www.skool.com/power-apps-community

@pandukawb 2 жыл бұрын

This is amazing! Thank you

@PowerAppsTutorial 2 жыл бұрын

You're welcome!! 😀👍

@st-wq3kj Жыл бұрын

Great tutorial

@PowerAppsTutorial Жыл бұрын

Glad you think so!

@mahfoudhbinsabbah6719 2 жыл бұрын

very good video thanks

@PowerAppsTutorial 2 жыл бұрын

Glad you liked it! Thanks so much!

@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! :)

@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: kzfaq.info/get/bejne/e82cZbd1z5bLlWg.html and another one here: kzfaq.info/get/bejne/hs5debNnp87UfWg.html

@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. 😥

@user-wz6cw4he1e 10 ай бұрын

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

@PowerAppsTutorial 10 ай бұрын

Yes it does

@jkc6144 7 ай бұрын

💯💯

@PowerAppsTutorial 7 ай бұрын

Glad it was helpful 😊

@user-wz6cw4he1e 10 ай бұрын

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

@PowerAppsTutorial 10 ай бұрын

Yes it does

@krishnaaveersinghhada9220 2 жыл бұрын

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

@PowerAppsTutorial 2 жыл бұрын

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 2 жыл бұрын

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

@krishnaaveersinghhada9220 2 жыл бұрын

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

@PowerAppsTutorial 2 жыл бұрын

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.

@vikingg97 2 жыл бұрын

This lady should do the PowerApps tutorials!

@PowerAppsTutorial 2 жыл бұрын

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

@deliyanehete8811 10 ай бұрын

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 10 ай бұрын

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

@kittydoes7600 2 ай бұрын

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

@PowerAppsTutorial 2 ай бұрын

Definitely, try it out!😀

@kittydoes7600 2 ай бұрын

@@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 10 ай бұрын

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