Solved: Use excel based on one drive for business as data source

I'm using official template of LEAVE REQUEST to build a canvas app and the data source is based on an excel as per official guide.

I found it will have compliance issue because everyone can check other one's leave information.

I tried to put the excel to SharePoint but I found I can't connect to a specific excel file but only "Document“ based on a SharePoint site.

I don't want to use LIST because I can't identify the filed name when I want to quote the data, e.g. "Detail" maybe "filed_1".

Is there any better solution for database which can meet compliance issue? Thanks.

Categories:

Use excel based on one drive for business as data source