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
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!
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!!
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
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.
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?
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
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. :)
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.
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
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.
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.
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.
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?
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.
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?
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.
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!
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
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
Best videos I've seen. Easy to understand, in plain English, applicable to everyday work. Nicely done!
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!
This video is exactly what I'm looking for, thank you so much
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!!
Thank you for your help Henry, greetings from Nicaragua
Thank you! I will check out your other videos
Great video, thank you! Easy to follow for someone new to PowerApps.
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
It's very helpful to me thank you,Good work!!
You explained from scratch so that's why very easy to understand.
Thank you!!
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.
Bro thank you so much for the video. It really helped me a lot🙏
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?
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
Hi many thanks for video . Could you pls recommend a complete guide for power app ?
Great video!Thank you～
Thanks for your help !
very helpful!! Thank you!!
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
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. :)
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.
Thank you clear and concise a great help thanks
Great video! Good job and thanks for sharing what you know.
Thank you! Love the feedback that you're giving - I will be sure to come out with more useful content for sure!
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
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.
Hello, is it posible to have a drop list to select for example a name on one of the cell in the power app?
Hi henry how to connect to a new excel file every day dynamically
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?
great video😀
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.
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.
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.
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??
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?
This is really appreciated information. I need to add a row to the excel. How can I do it? Please help me.
Thanks ,
I change the mode from edit to new this updated an excel workbook in OneDrive for business -
Maximum columns that can be taken in power apps from excel is 8. How to increase it.? Pls help
best video, you are amazing, but you forgot to mention how to add/ remove a record in the Excel table
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.
TY
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?
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.
what if i want to add an image link?
Good and straightforward, but you need a good mic mate
9:11 I hate that notification sound
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
Chinese???