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!
@maxdok102 жыл бұрын
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
@fullerstudent5 жыл бұрын
Best videos I've seen. Easy to understand, in plain English, applicable to everyday work. Nicely done!
@henryouang5 жыл бұрын
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!
@lessawlee2 жыл бұрын
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
@baovinhnguyen73262 жыл бұрын
This video is exactly what I'm looking for, thank you so much
@lisahiggins41455 жыл бұрын
Great video, thank you! Easy to follow for someone new to PowerApps.
@henryouang5 жыл бұрын
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
@gerahines4 жыл бұрын
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!!
@charlessu97382 жыл бұрын
very helpful!! Thank you!!
@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 Жыл бұрын
Great video!Thank you~
@jayamalaraut2734 жыл бұрын
It's very helpful to me thank you,Good work!! You explained from scratch so that's why very easy to understand. Thank you!!
@dilanvargas34214 жыл бұрын
Thank you for your help Henry, greetings from Nicaragua
@Andrewskji2 жыл бұрын
Thank you! I will check out your other videos
@prathyush17732 жыл бұрын
Bro thank you so much for the video. It really helped me a lot🙏
@chevydavidson92202 жыл бұрын
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?
@DanielCharpentier5 жыл бұрын
Great video! Good job and thanks for sharing what you know.
@henryouang5 жыл бұрын
Thank you! Love the feedback that you're giving - I will be sure to come out with more useful content for sure!
@fathurrahman44672 жыл бұрын
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
@nicholasbirkin90534 жыл бұрын
Thank you clear and concise a great help thanks
@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
@shwong6232 жыл бұрын
great video😀
@mathaem2 жыл бұрын
Thanks for your help !
@siamaksiamak55833 жыл бұрын
Hi many thanks for video . Could you pls recommend a complete guide for power app ?
@yooolie3 жыл бұрын
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. :)
@ivonsim89382 жыл бұрын
TY
@aryankrishna72704 жыл бұрын
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 Жыл бұрын
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.
@jinboxu10314 жыл бұрын
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 Жыл бұрын
Hi henry how to connect to a new excel file every day dynamically
@11550744 жыл бұрын
best video, you are amazing, but you forgot to mention how to add/ remove a record in the Excel table
@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
@bojanjosipovic16453 жыл бұрын
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?
@piratkeft1112 жыл бұрын
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?
@mark60794 жыл бұрын
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.
@tusharrawat97862 жыл бұрын
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.
@salvadorbanuelosm4 жыл бұрын
Hello, is it posible to have a drop list to select for example a name on one of the cell in the power app?
@jimreydaps3 жыл бұрын
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.
@account73312 жыл бұрын
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.
@riazahmedshaik4 жыл бұрын
This is really appreciated information. I need to add a row to the excel. How can I do it? Please help me. Thanks ,
@nicholasbirkin90534 жыл бұрын
I change the mode from edit to new this updated an excel workbook in OneDrive for business -
@dcm90584 жыл бұрын
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.
@spybungo3 жыл бұрын
Good and straightforward, but you need a good mic mate
@krutarthgohel55772 жыл бұрын
Maximum columns that can be taken in power apps from excel is 8. How to increase it.? Pls help
@factmeee4 жыл бұрын
what if i want to add an image link?
@feldeagle20854 жыл бұрын
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?
@feldeagle20854 жыл бұрын
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.
@benedictcontawe33557 ай бұрын
9:11 I hate that notification sound
@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