Amazing video bro! I've been struggling with PowerApps , and this video was very helpful! Thank you so much, you've earned a new sub! And I will continue learning with the rest of your videos.
Thanks a lot man. I took a course on another Plattform, paid, with a 5 hour content; and I feel this 15 minute viddeo gave me more knowledge than that one. Great content, great way to explain things; new sub here. Question: do you have any online courses?
@@andrewhess123 they explained some of the major topics of what it is and how to connect to each one, but they only worked there with lists. Actually I found you because I'm trying to work on an app that uses excel as a reference and I've been struggling to make a search bar filter and referencing the columns. If you could deepen a little bit over that (formulas/functions), it would be great.
Excellent! I've been having some problems with this, and you make it all so easy! Thank you! A question. In your gallery (around the 14 minute mark) you display Completed as a text value. Suppose we wanted to replace this with a checkbox. I would have expected that PowerApps would automatically translate the Excel values TRUE / FALSE into booleans, so the checkbox could directly reference ThisItem.Completed. But this does not work for me.
Hi Andrew, It would be possible to use a checkbox instead of the true/false text value. Most likely in the "Checked" property of the Checkbox you could write and if statement, If(ThisItem.Completed="true",true,false). This is also going to depend on if the checkbox is modern or not. But the reason is from excel it doesn't know it's a boolean value, it believes its a text value, thats why you use the " ".
@@andrewhess123 Hi, Andrew. Thanks for the reply. You are right: the checkbox works correctly when I get it to treat the Excel data as text, in the way you describe. I have tried using both modern and classic checkboxes: the behaviour is the same. I have also built a form in the app in order to edit the Excel data. Here, it is possible to simply submit the form using the value of a checkbox, without having to translate it into text. In this case, Powerapps does the translation automatically. It would be useful if MS were to make it so we did not need to treat the Excel data as text when reading it. Maybe they'll do that in due course.
May I ask you about picture , I use to add [image] in header and power app change data type into picture, when I do it with other power app, this time do not convert. Could u have recommend??
I'm connect table inexcel in Sharepoint / Onedrive with Power app. In the header of table, I add [image] such as Header is Figure >> Figure [image]. In power app, it will see data type like picture and it will keep url in excel and picture's kept in created automate folder in onedrive. My point is Excel in Onedrive almost completed everytime but sharepoin cannot. Do u have recommend?
I am making an app for my thesis and creating some filters using Cascading dropdown based on the first filter but I can not export those to an Excel file. How can I solve this ?
Question: I am using lookup values on a update form. When I save the look up value, the value gets saved successfully but the form displays the original value instead of what is saved
Hopefully, you still read these. You said you don't recommend Excel as a backend, but what else can I use? I'm a student just learning power apps and databases. I would love to use a database, but I'm not a business. I'm one guy storing personal data. I can't afford crazy pricing plans. Is there a better option than Excel?
SharePoint is the easiest... and if you want to explore more you can do "Dataverse for Teams". Or if you want to learn even more you can sign up for a free subscription to Azure and set up a Dev Azure SQL Server.
@@andrewhess123 Thank you for that quick response. I have always had an interest in computers but I'm diving into a lot of stuff that is new and overwhelming because of how many products, languages, etc... are out there. It's hard to know where to focus. Thank you for the suggestion. Take care.
@@mike9512 Well what do you want to learn? What's your final goal? Is it to make money? Is it to get a job? Is it to improve the world? I would start there 😀. My goal is actually just to learn, I love just learning everything it's actually a problem... 😅 Start with what is free, there's so much free content online and things you can try out.
@@mike9512 another suggestion is tell ChatGPT what you like to do and where you want to go.. then ask it to give you like 20 suggestions. Then find one of those and go from there 😃
Question: when i press submit button, it said "network error when using patch function: the requested resource is locked". and btw i use onedrive spreadsheet for the databases
Great video Andrew. However, you did not address the date issues between Excel and Power Apps and how to overcome the UTC issue with Power Apps. Any chance you could do a follow up on this?
Is there any way to edit data directly in a excel sheet inside of Power Apps? I don't want to create or edit a single value, but all the data from my table at the same time, is this possible?
@@andrewhess123 do you have any video or material about ir? I have a demand here at work that honestly I don't understand. They want do a simulation inside a dashboard of Power BI, but they want to see an excel sheet and edit it lol. It's impossible to do it with BI, I was wondering if with Power App I was able to solve it, but the easiest way was just simply use excel xD
Power Apps uses data sources, it does not take data from attachments and just have the data readily available. To do that you need to have a way for the attached data to be written to a data source. That would most likely be a workflow from Power Automate.
Hi, need your help, how users of power apps can upload Excel and system save data in share point according to their respective head, I have prepared power automate flow but it's not allowed to upload Excel, it saves data from Excel with provided location
Hi, Use an attachment in a SharePoint list, or here is more examples: www.matthewdevaney.com/power-apps-easiest-way-to-upload-files-to-a-sharepoint-document-library/
How to place the Add Image button. When pressed, the gallery on the phone opens, the image is selected, and it is linked to the Excel sheet Thanks in advance
You would have to do a LookUp on the largest id and then use the next id, but I would not recommend doing this in Excel, I would use SharePoint at very least to do autogenerated IDs. Else you could probably just do it on the Excel side, it is a table you could auto generate in Excel
Hi Hit, there are limitations with Excel, it is not a relational database. Delegation issues. Excel is the lowest form of a datasource for Power Apps/Power Platform. You lose on security, not as much version history. It's easier for people to break the connection by changing column titles or removing titles. People can break a whole powerapp by accidently moving an excel file. The main reason though, to use Excel is most people know Excel. If you get can get your users out of Excel to SharePoint, thats a plus, if you can get your users out of SharePoint to Dataverse or SQL that is even better.. but then you have to think about $$$
@@andrewhess123thank you, I actually got most of it but it was the part you did the look-up. I just can’t get my Look-ups working. I’ve used the Drop Down for the simple list. But I have a Country List of 195 which really needs a Look-Up could you just do a video for creating a Look-up for Countries- please
This is what i wanted. To filter the vertical gallery. Thanks!
Excellent! Thanks for watching!
Amazing video bro! I've been struggling with PowerApps , and this video was very helpful! Thank you so much, you've earned a new sub! And I will continue learning with the rest of your videos.
Nice! This is an old one but a good one 😀 been asked to remake it. May do that soon, probably next month
This tutorial literally taught me so much!! Exactly what I needed! Thank you loads!!
Thanks for watching mahiwayyy!
Great, my friend! You explain exactly I need! Many thanks!
Thanks for watching Carlos!
Awesome. You just fulfilled my criteria. Thank you ❣
Nice perfect! Hope you crush your goals!
Thank you for good tutorial, why in my excel the date is 1 hour before? Thank
Most likely you are 1 hour away from UTC time? Thanks for watching vega
Thanks a lot man. I took a course on another Plattform, paid, with a 5 hour content; and I feel this 15 minute viddeo gave me more knowledge than that one.
Great content, great way to explain things; new sub here.
Question: do you have any online courses?
Interesting, did they teach you dataverse right away? I'm thinking of working on some courses now.
@@andrewhess123 they explained some of the major topics of what it is and how to connect to each one, but they only worked there with lists.
Actually I found you because I'm trying to work on an app that uses excel as a reference and I've been struggling to make a search bar filter and referencing the columns. If you could deepen a little bit over that (formulas/functions), it would be great.
thank you, you're so helpful
Thank you for watching!
This is what something i wanted!! 😎 Thanks for making this video.
Thank you for watching Vikrama!
Excellent! I've been having some problems with this, and you make it all so easy! Thank you!
A question. In your gallery (around the 14 minute mark) you display Completed as a text value. Suppose we wanted to replace this with a checkbox. I would have expected that PowerApps would automatically translate the Excel values TRUE / FALSE into booleans, so the checkbox could directly reference ThisItem.Completed. But this does not work for me.
Hi Andrew, It would be possible to use a checkbox instead of the true/false text value. Most likely in the "Checked" property of the Checkbox you could write and if statement, If(ThisItem.Completed="true",true,false). This is also going to depend on if the checkbox is modern or not. But the reason is from excel it doesn't know it's a boolean value, it believes its a text value, thats why you use the " ".
@@andrewhess123 Hi, Andrew. Thanks for the reply. You are right: the checkbox works correctly when I get it to treat the Excel data as text, in the way you describe. I have tried using both modern and classic checkboxes: the behaviour is the same.
I have also built a form in the app in order to edit the Excel data. Here, it is possible to simply submit the form using the value of a checkbox, without having to translate it into text. In this case, Powerapps does the translation automatically.
It would be useful if MS were to make it so we did not need to treat the Excel data as text when reading it. Maybe they'll do that in due course.
@@andrewcrompton3444 Nice glad you got it working!
Very very good video. Thank you so much!!!!!
Thanks for watching Ping !
Superb explained.. Thank you sir.. Me beginner able to understand.
Thank you for watching Dileep
May I ask you about picture , I use to add [image] in header and power app change data type into picture,
when I do it with other power app, this time do not convert. Could u have recommend??
Hi Jametjm, I am a little confused with your question?
How to add image to Excel?
I'm connect table inexcel in Sharepoint / Onedrive with Power app. In the header of table, I add [image] such as Header is Figure >> Figure [image]. In power app, it will see data type like picture and it will keep url in excel and picture's kept in created automate folder in onedrive. My point is Excel in Onedrive almost completed everytime but sharepoin cannot. Do u have recommend?
Wow great 😊 looking for this type of contents, thank you so much!!! For answering my question. It's great knowledge share thanks again !!!💞💞
Awesome Manjunath! Glad it is helpful!
@@andrewhess123 waiting for upcoming parts !!🤠🤠🙏🙏🙏😍😍😍
😳😳 wow!! I was looking something like this from last 3 days finally got it 😇😇
Great! Thank you for watching Mahesh!
I am making an app for my thesis and creating some filters using Cascading dropdown based on the first filter but I can not export those to an Excel file. How can I solve this ?
Hi Tu Lan Lan, you need to patch them most likely.
@@andrewhess123 I'll take a look into that. Thanks for your advice.
Question: I am using lookup values on a update form. When I save the look up value, the value gets saved successfully but the form displays the original value instead of what is saved
Set the Default or DefaultSelectedItem to the LookUp value? Since it is correct probably reseting the default should work.
@@andrewhess123 Thank you, it worked
Hopefully, you still read these. You said you don't recommend Excel as a backend, but what else can I use? I'm a student just learning power apps and databases. I would love to use a database, but I'm not a business. I'm one guy storing personal data. I can't afford crazy pricing plans. Is there a better option than Excel?
SharePoint is the easiest... and if you want to explore more you can do "Dataverse for Teams". Or if you want to learn even more you can sign up for a free subscription to Azure and set up a Dev Azure SQL Server.
@@andrewhess123 Thank you for that quick response. I have always had an interest in computers but I'm diving into a lot of stuff that is new and overwhelming because of how many products, languages, etc... are out there. It's hard to know where to focus. Thank you for the suggestion. Take care.
@@mike9512 Well what do you want to learn? What's your final goal? Is it to make money? Is it to get a job? Is it to improve the world? I would start there 😀. My goal is actually just to learn, I love just learning everything it's actually a problem... 😅 Start with what is free, there's so much free content online and things you can try out.
@@mike9512 another suggestion is tell ChatGPT what you like to do and where you want to go.. then ask it to give you like 20 suggestions. Then find one of those and go from there 😃
@@andrewhess123best advice ever 😂
Question: when i press submit button, it said "network error when using patch function: the requested resource is locked". and btw i use onedrive spreadsheet for the databases
My guess is the document is currently open? When you try to patch or someone has it open?
i have a question: how can I add data from the input boxes in Power Apps into Excel? is it possible? if so thank you for responding
It's possible but Power Apps needs a Table Name in Excel to write to.
can power apps take information from two excel sheets to make an emailed payment letter?
Yes 100%, so can Power Automate
Great video Andrew. However, you did not address the date issues between Excel and Power Apps and how to overcome the UTC issue with Power Apps. Any chance you could do a follow up on this?
Is there any way to edit data directly in a excel sheet inside of Power Apps? I don't want to create or edit a single value, but all the data from my table at the same time, is this possible?
Possible with limitations by delegation.
@@andrewhess123 do you have any video or material about ir? I have a demand here at work that honestly I don't understand.
They want do a simulation inside a dashboard of Power BI, but they want to see an excel sheet and edit it lol. It's impossible to do it with BI, I was wondering if with Power App I was able to solve it, but the easiest way was just simply use excel xD
Hi, how can we fetch value in power app text input from attached excel file
Hi Ajay, you would need to connect to the data source of the excel file table, and then do a LookUp to the exact cell that you want to fetch.
@@andrewhess123 will it work for attached excel file by user?
@@ajayrathod7777 If you want to do something like this, probably needs to some sort of workflow by Power Automate
Power Apps uses data sources, it does not take data from attachments and just have the data readily available. To do that you need to have a way for the attached data to be written to a data source. That would most likely be a workflow from Power Automate.
@@andrewhess123 Thanks for your reply,does powerapp is reliable for performance can it handle users easily or it will break ?
hey can you do a video where you show how to search excel data and the app gives you all the other data from the row
Hi Samuel, Yes I can most likely do that. There are some limitations using Excel and Search but can we can talk about that too.
Hi Sir, Is it possible to create a ticketing system using Power Apps? If yes, could you please show a demo
Hi, need your help, how users of power apps can upload Excel and system save data in share point according to their respective head, I have prepared power automate flow but it's not allowed to upload Excel, it saves data from Excel with provided location
Hi, Use an attachment in a SharePoint list, or here is more examples: www.matthewdevaney.com/power-apps-easiest-way-to-upload-files-to-a-sharepoint-document-library/
Hi i made an app out of an excel file but now i want to filter the displayed data to another excel file. Can you make a video about that?
Good
Thank ya Mohamed!
How to place the Add Image button. When pressed, the gallery on the phone opens, the image is selected, and it is linked to the Excel sheet Thanks in advance
How to auto genrated id
You would have to do a LookUp on the largest id and then use the next id, but I would not recommend doing this in Excel, I would use SharePoint at very least to do autogenerated IDs. Else you could probably just do it on the Excel side, it is a table you could auto generate in Excel
You indicated that excel is not usually recommended as a backend, why is that?
Hi Hit, there are limitations with Excel, it is not a relational database. Delegation issues. Excel is the lowest form of a datasource for Power Apps/Power Platform. You lose on security, not as much version history. It's easier for people to break the connection by changing column titles or removing titles. People can break a whole powerapp by accidently moving an excel file. The main reason though, to use Excel is most people know Excel.
If you get can get your users out of Excel to SharePoint, thats a plus, if you can get your users out of SharePoint to Dataverse or SQL that is even better.. but then you have to think about $$$
@andrewhess123 great info, thank you for clarifying!
Mate please slow this down it’s good !
Should I recreate this with a new video?
@@andrewhess123thank you, I actually got most of it but it was the part you did the look-up. I just can’t get my Look-ups working. I’ve used the Drop Down for the simple list. But I have a Country List of 195 which really needs a Look-Up could you just do a video for creating a Look-up for Countries- please
@@andrewhess123yes! This is a great video, but I would love a slower, updated version!
@@Vivian.something Ok, I can write that down. With my newer videos I've been getting better at that. Thanks Vivian