@Uthhra
- If 'Implementation status' is a choice type column, go to SharePoint and change it to Single line of text
- In the app Settings, Activate the Named Formulas option
- in App.Formulas, make sure the ";" ends each line
T1 = ["Open","In Progress"];
T2 = ["ready for sepg review","under sepg review"];
T3 = ["Final","Archived"];
- Add a "+" icon to the screen with OnSelect:
- NewForm(yourform) ;Set(var,T1)
- Unlock the 'Implementation status' card
- hide the combobox
- Add a dropdown control named ddStatus
- Items property: var
- Default property: Parent.Default
- in the Update Property of the card
- replace the text with ddStatus.Selected.Value
- In the Gallery ">" icon
EditForm([@Form1]);
If(
ThisItem.'Implementation status' = "Open" || "In Progress",
Set(
var,
T2
),
ThisItem.'Implementation status'= "ready for sepg review" || "under sepg review",
Set(
var,
T3
),
Set(
var,
T1
)
)
or
EditForm([@Form1]);
Switch(
ThisItem.'Implementation status',"Open", Set(var,T1),
"In Progress",Set(var,T2),
"ready for sepg review", Set(var,T2),
"under sepg review",Set(Var,T3),
Set(var,T1)
)
