No video

Learn PowerApps - Learn How to Link PowerApps with Excel

  Рет қаралды 78,716

Henry Ouang

Henry Ouang

Күн бұрын

Пікірлер: 52
@alexscott473
@alexscott473 3 жыл бұрын
Finally - I tutorial where you make it from scratch instead of creating the app from the data! Been looking for a tutorial like this everywhere!
@maxdok10
@maxdok10 2 жыл бұрын
Very helpful. I used almost a week to figure out how to work on something like this only to be able to do it after watching a short video. Thanks
@fullerstudent
@fullerstudent 5 жыл бұрын
Best videos I've seen. Easy to understand, in plain English, applicable to everyday work. Nicely done!
@henryouang
@henryouang 5 жыл бұрын
Brendan, I appreciate your kind words! Truly hope these videos made your life easier. Thank you so much! Don't forget to click on the links in the description to connect with me more!
@lessawlee
@lessawlee 2 жыл бұрын
You are genius… I have been spending weeks trying to figure out how to link sheets and automate something but I think this is one step closer to my ideal app
@baovinhnguyen7326
@baovinhnguyen7326 2 жыл бұрын
This video is exactly what I'm looking for, thank you so much
@lisahiggins4145
@lisahiggins4145 5 жыл бұрын
Great video, thank you! Easy to follow for someone new to PowerApps.
@henryouang
@henryouang 5 жыл бұрын
Lisa, thank you so much for the kind words! I tried to go through every step of the way for both advanced and beginning users. Let me know what topics you or your friends would like to see some other tutorials - I'm planning on releasing more in the future! Please also share this to people you might know would like this kind of stuff. It keeps me making the videos for free! Thanks so much and happy building! Henry
@gerahines
@gerahines 4 жыл бұрын
Thanks for your tips... Question: 1- Is it possible to make new entries to that table from submitting the form? 2- Is it possible to link each field in the form to a specific table so that the user has a drop-down list from which to choose instead of inputting whatever they want? Thanks for your help!!
@charlessu9738
@charlessu9738 2 жыл бұрын
very helpful!! Thank you!!
@user-md3eh3bk5t
@user-md3eh3bk5t Жыл бұрын
Hello the tutorial is fantastic and it gives special recognition at my work place Thank you. The problem i encountered is when I tried to share the powerapp to my office colleagues & asked them to fill in the requirements the power app has not been shared to the fullest.when i use i have it everything of what i created but while saving & sharing to the user, the user hasn't getting the full data. Please advise on how to fix this.
@loojessie594
@loojessie594 Жыл бұрын
Great video!Thank you~
@jayamalaraut273
@jayamalaraut273 4 жыл бұрын
It's very helpful to me thank you,Good work!! You explained from scratch so that's why very easy to understand. Thank you!!
@dilanvargas3421
@dilanvargas3421 4 жыл бұрын
Thank you for your help Henry, greetings from Nicaragua
@Andrewskji
@Andrewskji 2 жыл бұрын
Thank you! I will check out your other videos
@prathyush1773
@prathyush1773 2 жыл бұрын
Bro thank you so much for the video. It really helped me a lot🙏
@chevydavidson9220
@chevydavidson9220 2 жыл бұрын
Currently I manually enter data in a leads sheet in excel. I plan on using Power Apps to enter data into my existing excel table. This will be very handy while on my phone out in the field to enter any new data. This is very helpful!!! The problem I am having is (3) of my columns in the excel sheet need to have data validation. My data validation uses a table in excel and the indirect function so the list is dynamic. In excel I select the cell then Type Alt, D, L and select list, then I type "=INDIRECT("tbl_name[table_column_name]")" of the table I'm pulling the validation from. How do I link the excel data validation list to populate the list of options in Power Apps?
@DanielCharpentier
@DanielCharpentier 5 жыл бұрын
Great video! Good job and thanks for sharing what you know.
@henryouang
@henryouang 5 жыл бұрын
Thank you! Love the feedback that you're giving - I will be sure to come out with more useful content for sure!
@fathurrahman4467
@fathurrahman4467 2 жыл бұрын
Hi Henry, you doing a great job. I love your work. I want to ask you about power apps. In this video you use power apps to write data on excel. If the data already there on excel, my question is : Can power apps only view data from excel? Example i write Ben Ng on the box then click search so the information about Ben Ng appears such as phone, email, city, country, etc. Thanks
@nicholasbirkin9053
@nicholasbirkin9053 4 жыл бұрын
Thank you clear and concise a great help thanks
@alangrady9825
@alangrady9825 Жыл бұрын
Hi henry, great info. just wondering does this work both ways i.e. if i edit the excel will it update the form in powerapps
@shwong623
@shwong623 2 жыл бұрын
great video😀
@mathaem
@mathaem 2 жыл бұрын
Thanks for your help !
@siamaksiamak5583
@siamaksiamak5583 3 жыл бұрын
Hi many thanks for video . Could you pls recommend a complete guide for power app ?
@yooolie
@yooolie 3 жыл бұрын
Henry, how does it work if i want to link a Workbook instead of a worksheet? How does the connection work? For example, i have all the master datasets in a "Master Data" sheet, and a transactional dataset in a transaction sheet. So if i build a Powerapp where i can initiate creating a new record, some of the dropdown listbox will read from the Master Data sheet and upon SAVE, it gets added to the Transactional Sheet. Do u have a video on that? Thank you in advance ! Getting excited going into Powerapps. :)
@ivonsim8938
@ivonsim8938 2 жыл бұрын
TY
@aryankrishna7270
@aryankrishna7270 4 жыл бұрын
good work henry...I have one query .. here u show how to edit data..but can we add new data(new row) in excel to show it in our gallery??
@emilpinter5772
@emilpinter5772 Жыл бұрын
Hello Henry, good job. But one question : is it possible to connect from Power App to personal OneDrive of user who is starting the App ? I mean every user has the same Excel with the same name.
@jinboxu1031
@jinboxu1031 4 жыл бұрын
Hi, your video has helped me a lot. And I have a question, why the data source cannot be connected in Form 1 in my case, which is shown in your video from 9:45. Thanks.
@rockninja213
@rockninja213 Жыл бұрын
Hi henry how to connect to a new excel file every day dynamically
@1155074
@1155074 4 жыл бұрын
best video, you are amazing, but you forgot to mention how to add/ remove a record in the Excel table
@Shilpis_Kitchen
@Shilpis_Kitchen Жыл бұрын
Hi, I wanted to fetch single column data from excel into powerapp Like i wanted to give Manager name and on submit button it should show all the employees reporting to that manager .... Can this be done in powerapp if yes how ? Please please help
@bojanjosipovic1645
@bojanjosipovic1645 3 жыл бұрын
Nice video! How do you create a new row? So lets say i want to add a new name with the information - how do i do that, so it is still linked to excel?
@piratkeft111
@piratkeft111 2 жыл бұрын
Great video! I have a problem with my excel. When i link it I cant get all the colums to show in my power app. It starts at column three, in the first colums i just have name and id-number. What can be wrong?
@mark6079
@mark6079 4 жыл бұрын
This is a great video tutorial. Do you have a video that has a search query function with two fields to authenticate like LASTNAME and Date Of Birth and show only the row data based on excel file as the output? Thank you for your response.
@tusharrawat9786
@tusharrawat9786 2 жыл бұрын
Hi Henry thank you so much for this wonderful tutorial.I was building oneapp in similar manner. I am facing one issue:- I have a gallery with edit button which redirects me to form. When I make changes using form they are reflected in the gallery immediately.But I wanted to place a user filter on the gallery so that only the user using the app could view his data using User().fullname.When i am placing this filter on gallery and then i go to edit and make some changes these changes are not getting reflected in the gallery or they are getting reflected after a 4-5 manual refresh .Could you please share some solution to this.
@salvadorbanuelosm
@salvadorbanuelosm 4 жыл бұрын
Hello, is it posible to have a drop list to select for example a name on one of the cell in the power app?
@jimreydaps
@jimreydaps 3 жыл бұрын
Hi Henry, I've got an Excel spreadsheet which has a column of weblinks. But when I've connected via Powerapps, the URLs aren't live, they are just text and can't be clicked and don't link.
@account7331
@account7331 2 жыл бұрын
Hello, if you are referencing 2 prior video tutorials in this video, could you please put the links to those videos in the subscription. Thank you.
@riazahmedshaik
@riazahmedshaik 4 жыл бұрын
This is really appreciated information. I need to add a row to the excel. How can I do it? Please help me. Thanks ,
@nicholasbirkin9053
@nicholasbirkin9053 4 жыл бұрын
I change the mode from edit to new this updated an excel workbook in OneDrive for business -
@dcm9058
@dcm9058 4 жыл бұрын
Hi Henry, I have connected my excel (from onedrive) to my App, now i have a text input box. and a button. the user enters his email id and if the email id is on the excel (table) he should be able to open the App. - sounds simple? yes, but it not for me:) my script goes: If(login1.text in Exceltable1.column1, set(isadmin,true),set(isadmin,false)); reset(login1; if(isadmin,navigate(to_next_screen), set(showaccesserror,true)) problem is - its not working...i really need your expertise on this. thanks dude.
@spybungo
@spybungo 3 жыл бұрын
Good and straightforward, but you need a good mic mate
@krutarthgohel5577
@krutarthgohel5577 2 жыл бұрын
Maximum columns that can be taken in power apps from excel is 8. How to increase it.? Pls help
@factmeee
@factmeee 4 жыл бұрын
what if i want to add an image link?
@feldeagle2085
@feldeagle2085 4 жыл бұрын
I have created an excel doc. Formatted it as a table, I have 3 different tables. For whatever reason it is loading in the boxes but as soon as i hit live it says "No items to display" .I have removed the connection and reconnected, i have deleted my entire project and started over, i have redone the tables. I just have a simple app that matches what you have here and it still will not bring in any data. It clearly can see the tables because it gives me the fields. Help anyone?
@feldeagle2085
@feldeagle2085 4 жыл бұрын
BTW Ive searched many videos. This was by far the best one I have seen, explained everything very well and started from scratch which helps tremendously.
@benedictcontawe3355
@benedictcontawe3355 7 ай бұрын
9:11 I hate that notification sound
@janavamp1976
@janavamp1976 Жыл бұрын
Could you please speak and point more slowly? If I want to learn something or improve, then please also for the other slower samples. Thank you
@m.asifhussain1730
@m.asifhussain1730 2 жыл бұрын
Chinese???
Learn PowerApps - Autofill Templates in Sharepoint Tutorial
20:58
QTT - Power Apps Excel is a terrible data source
10:48
Shane Young
Рет қаралды 42 М.
My Cheetos🍕PIZZA #cooking #shorts
00:43
BANKII
Рет қаралды 27 МЛН
Unveiling my winning secret to defeating Maxim!😎| Free Fire Official
00:14
Garena Free Fire Global
Рет қаралды 6 МЛН
ПОМОГЛА НАЗЫВАЕТСЯ😂
00:20
Chapitosiki
Рет қаралды 28 МЛН
Little brothers couldn't stay calm when they noticed a bin lorry #shorts
00:32
Fabiosa Best Lifehacks
Рет қаралды 19 МЛН
Learn to connect: PowerApps Excel Spreadsheet hosted in OneDrive
22:00
Microsoft PowerApps - First App with Connection to Excel
34:53
Paul Vesey
Рет қаралды 18 М.
Web Scraping Made EASY With Power Automate Desktop - For FREE & ZERO Coding
13:11
Microsoft Power Apps for Beginners   From Idea to App!
24:47
Teacher's Tech
Рет қаралды 42 М.
How to Connect Power Apps to an Excel Spreadsheet - Beginner Tutorial
30:53
PowerApps Tutorial
Рет қаралды 39 М.
This Simple File Management System Changed My Life!
9:27
Jeff Su
Рет қаралды 1,2 МЛН
How can I add hyperlinks to Power Apps, its Gallery and Data table?
21:40
My Cheetos🍕PIZZA #cooking #shorts
00:43
BANKII
Рет қаралды 27 МЛН