You’re offline. This is a read only version of the page.
Announcements
3
I have a table with a column which values can't be edited by users. I can easily configure Dataverse to do so, either inside form by changing column type to read-only or by using Business rules. However I realized that it can by easily avoided by editing records in Excel Online that does not inherit Dataverse security model and while saving it does not respect neither form security nor business rules.
The problem is that I need to show this column in the main view and I need to allow users to edit data in Excel Online. So is there any way to prevent saving changes in a certain column from Excel Online?
Hi @Hound55,
To really protect this you would need to leverage Field Level Security in Dataverse or the user will be able to get around this and be able to modify the field through an integration (dataflow), through Excel Online or Advanced Find creating their own view with the field and then exporting to Excel and Importing. The only way to really secure this is to enable field level security profiles.
https://docs.microsoft.com/en-us/power-platform/admin/field-level-security
Share
Report
All responses (
Answers (
