Hello,
I am building a canvas app using dataverse. I have a dataverse table with basic and sensitive columns, and have some users who can see all columns and some who cannot see the sensitive columns, set using column security profiles (https://docs.microsoft.com/en-us/power-platform/admin/set-up-security-permissions-field).
I want to have a button to update the value of one of the basic columns, based on the ID. I have tried the following:
Patch('Shelter users', First(Filter('Shelter users', 'ID'="0000")), {'Name': "TESTING"})
where 'Name' is the name of a basic column. However this does not work for the users with restricted access, even though they still have read and write access to the 'Name' column and the ID column. It does not update the 'Name' column and there is no error. It seems that this is because the First(Filter part is returning nothing. I have also tried using the UpdateIf function, and had the same problem. The formula does work correctly for users with access to all columns.
Is there a way to update the value of a record column based on the ID, which will work in this situation where the user does not have permission to view all columns?
Thanks!
