Series 1 - How to Use Excel as DataSource

Views (22)

Ram Prakash Duraisamy

5,593 Super User 2025 Season 2

Like(0)

Report

Implementation Steps:

Generate an Excel like below and store it in your Local
Select all Rows and convert it to Table
Once done , Login to One drive for Business then Create a Folder and Import this Excel
Now navigate to https://make.powerapps.com
Select Start with data
Once the Page Gets loaded select External Datasource then select "EXCEL" as datasource
Validate Connection and Select the Excel Table
For now i select Auto-generate Values so that it will create a new GUID Column to map between Excel and PowerApps
Once clicked on Proceed it will Create App with below operations
1. Create
2. Update
3. Delete
Now if you click New and enter all the details and click Save it will save to excel automatically
Click on Edit and Update the values
Click on Delete the record gets removed form the Excel Automatically

Conculsion:

If you are having minimal number of operations you can easily use Excel as backend to perform operations