I am having trouble with a formula on an OnSelect property of a button. The formula is below:
If(IsBlank(DataCardValue78.Value),
Set(VarVisible2, true),
Switch(!IsBlank(LookUp('PDA Volunteer Data', Title=DataCardValue1.Value)),
And('Role Description'.Value & "Responder", 'Role Description'.Value & "Supervisor"),
Navigate('Stock&RNAFScreen3',ScreenTransition.Fade,{Title: DataCardValue8.Value}); SubmitForm(Form5); ResetForm(Form5),
And('Role Description'.Value & "Responder", 'Role Description'.Value & "Lead"),
Navigate('Stock&RNAFScreen3',ScreenTransition.Fade,{Title: DataCardValue8.Value}); SubmitForm(Form5); ResetForm(Form5),
And('Role Description'.Value & "Intervenant(e)", 'Role Description'.Value & "Superviseur(e)"),
Navigate('Stock&RNAFScreen3',ScreenTransition.Fade,{Title: DataCardValue8.Value}); SubmitForm(Form5); ResetForm(Form5),
And('Role Description'.Value & "Intervenant(e)", 'Role Description'.Value & "Responsable"),
Navigate('Stock&RNAFScreen3',ScreenTransition.Fade,{Title: DataCardValue8.Value});SubmitForm(Form5);ResetForm(Form5)),
Set(varGroup3ErrMessageVisible,true)
)
The format of 'Role Description' is not recognized in the app environment. Is there a different format for model-driven apps than canvas apps for column names with a space in the name?
Ange
