Part 1: Power Apps with Excel, creating tables, lookup columns, and changing column types

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!

[SkMustafijurrahaman]

Awesome. You just fulfilled my criteria. Thank you ❣

[dillep]

Superb explained.. Thank you sir.. Me beginner able to understand.

[mahirazabin]

This tutorial literally taught me so much!! Exactly what I needed! Thank you loads!!

[Shh...Kannada]

This is what something i wanted!! 😎 Thanks for making this video.

[CarlosSoares-ybmp]

Great, my friend! You explain exactly I need! Many thanks!

[amitabhphatak]

This is what i wanted. To filter the vertical gallery. Thanks!

[kannadahollywood]

Wow great 😊 looking for this type of contents, thank you so much!!! For answering my question. It's great knowledge share thanks again !!!💞💞

[maheshraghuvar]

😳😳 wow!! I was looking something like this from last 3 days finally got it 😇😇

[Sobec]

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?

[saikrishnamandala]

Hi Sir, Is it possible to create a ticketing system using Power Apps? If yes, could you please show a demo

[RamiMaach]

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?

[jametjm]

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??

[habibindraalivito]

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

[tulanlan]

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 ?

[vidsbyme]

can power apps take information from two excel sheets to make an emailed payment letter?

[samuel-tjpe]

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

[ykzojep]

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

[ptlzcxn]

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

[diogoasenjo]

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?

[ajayrathod]

Hi, how can we fetch value in power app text input from attached excel file