Oct 19 2022 05:12 AM
Hello! I have a sharepoint list which has in it a couple of multi line columns that fills with a power automate flow, the thing is that I dont wan't those columns to be editable, I tried the trick of using a calculated column but it doesn't work for multi line columns. As well following these steps:
This works! But only for newly created columns, mine are already created and with data in it.
Is there a way to make this columns non editable?
Thank you all for taking time to read this!
Oct 19 2022 06:01 AM
If you set the multi-line-column to "Rich text" from the classical list settings dialog then the column is no longer editable in data grid view.
(Do not do this directly from the column actions in the modern ui. This sets it to to "Enhanced rich text" and and does not work with that)
Then you could customize the column in the form and set the conditional formula for your column to just =false
Then the field will not be displayed in forms and cannot be edited in grid view by a limitation in the grid view editor..
But make sure that you flow can still update the field after you switched it to "Rich Text".