You’re offline. This is a read only version of the page.
559
Hi All,
I have a gallery and form. When a item is selected in gallery it navigates to the form where I have a column called Implementation status combo box which lists down values. When the user is coming for the first time and the implementation status Colum has blank value, it must display only first two values in combo box( i.e. Open/ in progress) . When Open/ in progress is selected and saved and when the user comes the second time the combo box should display the next two values in combo box( ready for sepg review/under sepg review). Likewise it must display next two values. Any help / suggestion on this.
The method which you suggested above will it work without changing the column to single line of text.
I can not change the column Implementation status to single line of text because I'm using the column in few other screens also. In my case it should be when the respective item is selected from gallery my form which has this column Implementation status should load the respective values.
Share
Report
All responses (
Answers (
T1 = ["Open","In Progress"];
T2 = ["ready for sepg review","under sepg review"];
T3 = ["Final","Archived"];
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)
)
#1
WarrenBelz
146,594
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,928
Most Valuable Professional
