cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KED
Frequent Visitor

Flow to set Dataverse fields to read only

Is there a Power Automate action to set Dataverse fields to read only? 

 

Use case: a flow with an Adobe Sign sends a PDF for signature, populating that PDF's fields with data from a Dataverse "Application" table. A second flow has a trigger upon that signature's status being signed, and writes the values of PDF fields filled in by the user back into the Dataverse "Application" table.

 

At this point, because the document was signed and the data in that document constitutes a permanent record, we need the corresponding data in Dataverse to be read only.  Do I have to resort to a workaround like creating a field called "IsSigned" and setting it to Yes when the document is signed, and having IsSigned set to Yes being the condition in a business rule to lock all of the fields in the Application table? (Of which there are over 60 - that would be a nightmare business rule). 

2 REPLIES 2
dpoggemann
Super User
Super User

Hi @KED,

 

Couple of things here...

1.  You could actually inactivate the record (bound action) if you want it to lock all fields as this will happen by default.

2.  The other approach you mentioned is what I would do if there were a limited number of fields that need to be locked on the entity.  You can update this field through a Power Automate flow.

 

Hope this helps.  Please accept if answers your question or Like if helps in any way.


Thanks,

Drew

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew
EricRegnier
Super User
Super User

Hi @KED,

The out-of-the-box method to set a record as read-only is with the Status (statecode) and Status Reason (statuscode). Add a new Status Reason that's associated to the Inactive Status (best to use the classic solution explorer for this). Save all and Publish All. Then in Power Automate, you can set the row as inactive with the standard Update a row Dataverse action.

EricRegnier_0-1620264957120.png

Hope this helps!

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power Apps Community Call Jan. 2022 768x460.png

Power Apps Community Call

Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (1,270)