Inherited App from departed employee - Need to make updates but LOST!!!

[CVannest]

I've recently inherited a PowerApp from a departed employee.  I've gone into it pretty blind but figured out 99% of the setup, but now the users want some changes made and I'm at a stand still.

The basic concept is an "Exit Interview" portal for employees who leave the organization.  One of the fields is "Call Status" which could be "Completed, 1st Attempt, 2nd Attempt or Unable to Connect".  

Most of the input fields on the form are REQUIRED, however what they are asking for is if any selection other than "Completed" is selected from the drop down all other fields are no longer REQUIRED so they can easily submit the form without filling out the rest of the information that WOULD have come from the departing employee.

Any insights on this would be GREATLY appreciated!!!

[RandyHayes · Accepted solution]

@CVannest 

If the columns are listed as required in your datasource, then you will not be able to submit the record without information in those columns.  

However, if your form is what is dictating the "required", then you can provide a formula in the Required property of those datacards to be based on the Call status.

I would need more information on the call status controls in your form to be able to present a suggestion on the formula, but the concept is simply altering the required property based on the value entered.

I hope this is helpful for you.

[CVannest]

Randy,

Thank you for the response.  The fields are NOT required in the List in SharePoint that they write to, they are only required on the PowerApps form.

The Call Status field is a Drop Down that lists choices from the SharePoint List.  DisplayFields is set to ["Value"] as is the SearchFields.  

There are 19 other fields in the form that are REQUIRED in the PowerApps form only.  What would be the best way to show you the setup?  

[CVannest]

I attached a couple of screen shots of the app.

[CVannest]

   This is the "Call Status" column in the SharePoint List that the form uses to pull the selections.

[CVannest]

I think you've already helped me more than you know!  I was able to add this to the "Required" field for the first card "First Name" and when anything other than "Completed" is selected the card becomes not required.

DataCardValue4.Selected.Value="Completed"

[RandyHayes]

@CVannest 

Yes, I was just in the process of typing that out!!

Other than that, the rest of the setup seemed fine from what you provided.  The only distinction to keep in mind is that you are working with a Combobox in DataCardValue4 and not a Dropdown.  They are two different types of controls.

But, that is the formula you need for the Required property!