Showing results for 
Search instead for 
Did you mean: 
Advocate II
Advocate II

Leave request template - no data in Excel

Hello Everyone,

I am new at Powerapps and would be glad to get help from You. I am trying to create app by using Leave request template. As there is a lot of information about it I managed to work with Collections in order to create new leave types, change entitlement and etc., but cannot figure out what is the problem that after submitting and approving requests no data is saved in connected data source (Excel stored in One drive for business).

I've tried to test it with completely new (not customized app) and situation is the same - no data is uploaded to Excel.

Maybe there should be some additional modifications made for this app in order to get it work or some settings should be enabled for my account? 


Thank You for Your help!

Solution Sage
Solution Sage

Does the excel file have a saved table in it? As you add an excel as a datasource, you'll need to collect the table information inside the excel file and not the file itself. This way you can save multiple tables in one excel and extract data from all of them. 


If this is the case, try to save your data in the excel file into a table. You can do this by selecting all your data, then go to the Insert tab and press Table. It will put the data into a table which you can then save with a name. When you then open this file as a datasource in Powerapps, you can select this table collect and store data.




I'm not sure if it works by just extracting data form an excel file, but for other datasources you as well have to link with a source, and search for tables inside the datasource. If you want to store data, the application has to know the datasource, the table and in which column the data has to be stored.


I hope this helps, if this is actually the case, but you can try.


Thanks for Your answer, but I guess this is not the case as my Excel file has three different sheets (Holiday, Balance, Leave) with formated tables inside. All of them are connected as data sources to Leave request app.

Helpful resources

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,592)