Hi all
I have two conditional scenarios I'm trying to apply to my PowerApps form. In both cases the conditions apply when the form is in view mode, but don't work when in edit mode.
Case #1:
I have Yes/No fields with conditionally required test fields which must be filled if the related "Yes" field is marked as such. Visible for the conditionally required cards are set to If(DataCardValue.Value = true, true)
Case#2
I have an approval Yes/No field which should only be editable by the manager. I have a distinct list with managers contact details and a field indicating if they have approval authority. This data source was added to my model and I've set the following condition
Set(ManagerApprover,LookUp(DivisionMetrics,'CurrentManagerEmail'=User().Email))
- I've tried placing this in OnStart, OnVisible, StartScreen (and combinations of the 3)
My data card visibility is set to ManagerApprover.Approver where "Approver" is the field in the Manager's Registry that notes approval authority Y/N.
- I've tried placing this in DataCard, DataCardKey, DataCardValue (and combinations of the 3)
In both cases the conditions apply when the form is in View but when Edit is selected all fields are visible/editable.
Noting that for Case#2 the Managers may delegate their approvals to other team members, and they have a separate method of logging delegated approvals outside the form itself. We want to retain this function.