cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TW001
Helper I
Helper I

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.

Snipaste_2022-07-26_22-52-02.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
timl
Super User
Super User

@TW001 

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.

View solution in original post

1 REPLY 1
timl
Super User
Super User

@TW001 

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.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

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