Answered

Lock attachment(file data type) fields based on business process flow stage

(0) Share

Report

Posted on by radusitaru Microsoft Employee

Hello team,

I am looking to find a method to lock/unlock attachment(file data type) fields based on business process flow stages.

I know that file columns cannot be locked/unlocked with business rules.

Is JavaScript the only solution in this case?

If so, could you please help with a code template for that?

Regards,

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

AhmedSalih 6,678 Moderator on at

Like (1)

Report
@radusitaru , I had similar scenario to lock an attachment field but I wasn't verifying against BPF stage, it was against Employment status field value. Here is my code for that purpose.
function setFieldDisabled(executionContext) { var formContext = executionContext.getFormContext(); var employmentStatus = formContext.getAttribute('EmploymentStatus').getValue(); var attachResume = formContext.getControl('ResumeAttachement'); if (employmentStatus == 'New' ) {attachResume.setDisabled(false);} else {attachResume.setDisabled(true);} }

Regards,
Ahmed
If my reply helped you, please give a 👍. And if it has solved your issue, please consider Accept it as the Solution to help other members in the community find it more.

Was this reply helpful? Yes No
Verified answer

radusitaru Microsoft Employee on at

Like (1)

Report
Hello Ahmed. Your reply helped me a bit, but here is the code that made it work:

//Main function to lock attachment field function cra5a_LockAttachment(executionContext) { //Get context var formContext = executionContext.getFormContext(); //Trigger onStageChange formContext.data.process.addOnStageChange(onStageChange); //Trigger onLoad formContext.ui.addOnLoad(onLoad) } //Same function as main, but triggered onStage change function onStageChange(executionContext){ var formContext = executionContext.getFormContext(); var attachment1 = formContext.getControl('cra5a_file'); var attachment2 = formContext.getControl('cra5a_file2'); var stageName = formContext.data.process.getSelectedStage().getName(); if (stageName == '1. DCA Specialist Input') {attachment1.setDisabled(false);} else {attachment1.setDisabled(true);} if (stageName == '4. Calibration Input') {attachment2.setDisabled(false);} else {attachment2.setDisabled(true);} } //Same function as main, but triggered onStage change function onLoad(executionContext){ var formContext = executionContext.getFormContext(); var attachment1 = formContext.getControl('cra5a_file'); var attachment2 = formContext.getControl('cra5a_file2'); var stageName = formContext.data.process.getSelectedStage().getName(); if (stageName == '1. DCA Specialist Input') {attachment1.setDisabled(false);} else {attachment1.setDisabled(true);} if (stageName == '4. Calibration Input') {attachment2.setDisabled(false);} else {attachment2.setDisabled(true);} }

Was this reply helpful? Yes No
Gras8 2 on at

Like (0)

Report

For me this is not working the disabled false when the status is closed.
Are there any way to enabled it?

Was this reply helpful? Yes No