Have a challenge. We have a spreadsheet that contains over 1000 rows of essentially IT related employee information. Each row consists of multiple fields over about 20 columns. The information is sensitive in nature in that, we do not want someone to just copy the spreadsheet and steal all the information - from a security perspective, and also in order to limit information available to competitors. I am trying to think of a way to limit a users ability to see only 1 row at a time. In addition to users needing the ability to view information/records (ideally limited to 1 row at a time) - they also need the ability to edit information, and to create new records.
My idea was to build a power app that presents to non-admin users in the tenant the information as described above, in such a way that, they are provided two fields in the app where they can type either a name or an e-mail in one or the other field, and the app returns only the one record (all information in a row) on that one individual. The User would also have the ability to edit the information in the row - and update the spreadsheet record/row, or, the user could create a new record - which would add a new row to the spreadsheet.
The one troublesome piece to this that I can't see a way around is, in order to give a user access to the app, they would also need access to the spreadsheet - the only way to limit access would be thru obscurity.... which is not an acceptable approach.
Does anyone have any thoughts or ideas on how best to solve the challenge?
Thanks.
Gregg Powell
AZ