You’re offline. This is a read only version of the page.
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.
Unfortunately, it's not possible to implement this type of record level security for both Excel and SharePoint datasources. As you've seen, the user can open the underlying Excel file or SharePoint and see all entries.
A viable alternative would be to use Dataverse, which supports record level security at a user level.
#1
WarrenBelz
223
Most Valuable Professional
#2
MS.Ragavendar
110
#3
stampcoin
80
Share
Report
All responses (
Answers (
