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?
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?
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.
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: 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
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
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
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/
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 $$$
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
Superb explained.. Thank you sir.. Me beginner able to understand.
Thank you for watching Dileep
Awesome. You just fulfilled my criteria. Thank you ❣
Nice perfect! Hope you crush your goals!
This is what i wanted. To filter the vertical gallery. Thanks!
Excellent! Thanks for watching!
Very very good video. Thank you so much!!!!!
Thanks for watching Ping !
Great, my friend! You explain exactly I need! Many thanks!
Thanks for watching Carlos!
This tutorial literally taught me so much!! Exactly what I needed! Thank you loads!!
Thanks for watching mahiwayyy!
This is what something i wanted!! 😎 Thanks for making this video.
Thank you for watching Vikrama!
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 !!🤠🤠🙏🙏🙏😍😍😍
thank you, you're so helpful
Thank you for watching!
😳😳 wow!! I was looking something like this from last 3 days finally got it 😇😇
Great! Thank you for watching Mahesh!
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?
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?
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!
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: 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?
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
Hi Sir, Is it possible to create a ticketing system using Power Apps? If yes, could you please show a demo
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
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?
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.
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
can power apps take information from two excel sheets to make an emailed payment letter?
Yes 100%, so can Power Automate
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 ?
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/
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!
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