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

Поділитися
Вставка
  • Опубліковано 5 вер 2024

КОМЕНТАРІ • 46

  • @PowerAppsTutorial
    @PowerAppsTutorial  2 роки тому +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
    @cotterdev3312 2 роки тому +6

    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!

  • @theodoraclark5111
    @theodoraclark5111 3 місяці тому

    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!

  • @fatemahalawadhi5961
    @fatemahalawadhi5961 Рік тому

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

  • @lstgeorge7370
    @lstgeorge7370 Рік тому +2

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

  • @st-wq3kj
    @st-wq3kj Рік тому +1

    Great tutorial

  • @RJ85bob
    @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
      @PowerAppsTutorial  Місяць тому

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

  • @pandukawb
    @pandukawb 2 роки тому +1

    This is amazing! Thank you

  • @mahfoudhbinsabbah6719
    @mahfoudhbinsabbah6719 2 роки тому +1

    very good video thanks

  • @rossmarvin6078
    @rossmarvin6078 Рік тому +1

    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
      @rossmarvin6078 Рік тому +2

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

    • @PowerAppsTutorial
      @PowerAppsTutorial  Рік тому

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

  • @Goenie2005
    @Goenie2005 Рік тому +1

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

  • @maliffi
    @maliffi Рік тому +1

    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
      @PowerAppsTutorial  Рік тому

      Sure! I cover popup windows here: ua-cam.com/video/Egl2TDj0ge4/v-deo.html and another one here: ua-cam.com/video/Ph-FP6BhpM4/v-deo.html

  • @user-wz6cw4he1e
    @user-wz6cw4he1e 11 місяців тому

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

  • @user-wz6cw4he1e
    @user-wz6cw4he1e 11 місяців тому

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

  • @krishnaaveersinghhada9220
    @krishnaaveersinghhada9220 2 роки тому +1

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

    • @PowerAppsTutorial
      @PowerAppsTutorial  2 роки тому +1

      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
      @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
    @krishnaaveersinghhada9220 2 роки тому +1

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

    • @PowerAppsTutorial
      @PowerAppsTutorial  2 роки тому +1

      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
    @deliyanehete8811 11 місяців тому

    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
      @PowerAppsTutorial  10 місяців тому

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

  • @jkc6144
    @jkc6144 8 місяців тому

    💯💯

  • @kittydoes7600
    @kittydoes7600 2 місяці тому

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

    • @PowerAppsTutorial
      @PowerAppsTutorial  2 місяці тому

      Definitely, try it out!😀

    • @kittydoes7600
      @kittydoes7600 2 місяці тому

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

  • @michaeldell6309
    @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
      @PowerAppsTutorial  10 місяців тому

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

  • @vikingg97
    @vikingg97 2 роки тому +2

    This lady should do the PowerApps tutorials!

  • @FernandoHunth
    @FernandoHunth Рік тому

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