Power Platform Community Forum Thread Details

I might be missing something here but if I have a table that includes a required file column how do I ensure that the record has a file uploaded to that column as it is a 2-step operation (1. Create the record and then 2. Upload the file).

The file column is only required on subsequent saves, not the initial creation.

This must be a common use case but I can't figure out how to be certain that a file is uploaded (I need it for compliance checks later).

Essentially I want to have a record that has some required text columns AND a required file column and know 100% that everything is entered.

At the moment there is a risk that a user enters the required text, hits save and never uploads the file.

Do I need to come up with a different design/strategy?

Categories:

Building Power Apps

@nuxibyte

You can use a business rule to validate this. Add condition to check if the created on field has value and then continue with your business rule to make the necessary field as required.

If you want, you can use a JS to make it required after the record has been created.

function setFiedrequirementasrequired(executionContext)
{
 // Getting formContext 
 var formContext = executionContext.getFormContext();
 var formType= Xrm.Page.ui.getFormType();
 // Check condition if page is create or update and if it is update, set the fields are required.
 if (formType == 2)
 {
 //setting Email field requirement as required/mandatory.
 formContext.getAttribute("emailaddress1").setRequiredLevel("required");
 // setting Mobile phone field requirement as required/mandatory.
 formContext.getAttribute("mobilephone").setRequiredLevel("required");
 }
 else
 {
 //setting Email field requirement as none.
 formContext.getAttribute("emailaddress1").setRequiredLevel("none");
 // setting Mobile phone field requirement as none.
 formContext.getAttribute("mobilephone").setRequiredLevel("none");
 
 }
}

Hope this helps.

Cheers!