Using Excel as the data source for PowerApps

This video demonstrates how to use Excel files as the data source for PowerApps and discusses things to be aware of when you use this pattern. This video demonstrates how the Leave Request PowerApps uses Excel as a data source.

Download this sample here:

The Leave Request PowerApps sample includes the following functionality:

- Employees can create leave requests and submit to their managers.
- Managers can easily administer leave requests in a unified view.
- Easily track leave status, prominent company holidays and leave balance

[jimreydaps]

Hi Todd,

I've got an Excel spreadsheet which has a column of weblinks. But when I've connected via Powerapps, the URLs aren't live, they are just text and can't be clicked and don't link.

[kimberlymedecke]

Is is possible to sync the leave request power app with the ms calendar?

[arronkearney]

Hi Todd, I enjoy the video but my version of power apps doesn't have the Make my own app button, thus I am struggling to create the leave request app, do you know of a fix for this?

[dcm]

hi Todd,
is it possible to collect data from an excel file (saved on my sharepoint site) and populate my data collection in powerapps?

Thanks

[elizabetlastiurlumbantorua]

I can connect and retrieve data from OneDrive Excel to PowerApps. But when I changed data in PowerApps, data in Excel did not change. Can we update data from PowerApps to Excel?

[arishtat]

Creating the new PowerApp from the Leave Request template does NOT create the Excel file, nor are there data sources for the different Excel worksheets. There is no Make my own app button.

[factmeee]

how about adding unique images link from excel?

[georgewinters]

Hi Todd:
Thanks for this informative video.
I have used Excel as a data source for Powerapps, and it's very cool.
But there isn't a way to determine the source _workbook_ for an existing Powerapps data connection. Is there?

[mohammedaamirmansuri]

Hey @Todd Baginski

Very good tutorial.

I have one question. When I tried to download the leave request powerapp then it didn't had much code as shown by you on Submit Request button. Did you add that code yourself or is there any problem with my PowerApp.


Appreciate if you could upload your version somewhere for reference for people like me.

[petergyulalancz]

Hi Todd, Thanks for the informative video, Can you please tell me how can I download this sample? when click on the link my own power applications are loaded.

[Nsfratu]

Hi Todd. Great video! would it be possible to share again the sample please? Thanks!

[solvimar]

Hi Todd, thanks for great video.
Could you explain the difference between a datasource such as excel datasource and a collection?

[ashokpershad]

Great Video, I have one query, I have Excel stored in Department Sharepoint and I wanna use it to create Powerapps, so that all information can be easily visible to everyone who have access to Sharepoint whenever they update details in PowerApps. Right now I created an App using Excel stored in One Drive for Business. In this case if someone want to use this app then i have to give them write access to the file and folder stored in my One drive for Business.