Part 1: Power Apps with Excel, creating tables, lookup columns, and changing column types
Вставка
- Опубліковано 20 лип 2024
- Sometimes a client just wants excel because that is where they are comfortable. Even though excel is usually not recommended we can still do some Awesome things there with Power Apps.
In this video we create an Excel Table. Add a Power App Form, with different column types. We even use an excel table as a LookUp Column. Finally we create a Gallery with a Filter.
Stay tuned next week and we will add 5 filters and even do some fun things in Excel.
Thank you for watching this is My SharePoint Questions and I am Andrew Hess.
Chapters:
0:00 Introduction
1:48 Create a new Excel Table
2:45 Connect to Excel Data Source
3:50 Add Power Apps Edit Form
4:35 Changing Column Types
7:08 An Excel Lookup Table
10:14 Convert a field to a Checkbox
11:18 Convert a field to a DatePicker
12:00 Testing
13:18 Creating a Gallery with a Filter
16:19 Coming soon in Part 2!
Awesome. You just fulfilled my criteria. Thank you ❣
Nice perfect! Hope you crush your goals!
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
This is what i wanted. To filter the vertical gallery. Thanks!
Excellent! Thanks for watching!
This tutorial literally taught me so much!! Exactly what I needed! Thank you loads!!
Thanks for watching mahiwayyy!
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?
Great, my friend! You explain exactly I need! Many thanks!
Thanks for watching Carlos!
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 !!🤠🤠🙏🙏🙏😍😍😍
😳😳 wow!! I was looking something like this from last 3 days finally got it 😇😇
Great! Thank you for watching Mahesh!
thank you, you're so helpful
Thank you for watching!
Hi Sir, Is it possible to create a ticketing system using Power Apps? If yes, could you please show a demo
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 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
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?
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?
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.
can power apps take information from two excel sheets to make an emailed payment letter?
Yes 100%, so can 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/
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
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, 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 ?
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!