Hello Community,
Hope you're all doing well.
I have 2 drop down Boxes
Production with Items ["",OK", "Pending"]
Quality with Items ["","Approved", "Rejected"]
These are saved in SharePoint List in which the columns are of type CHOICE.
Now My requirement, When the value in Quality is Changed to Rejected then the value in Production should be changed to Pending. and when hit on save this item is saved in the SharePoint list .
but when production comes and takes a look at the pending and then change to OK it should be saved as OK and this should be displayed in the Dropdown box of Production.
I used
Default: ThisItem.Production.Value (for Prod Dropdown)
Used the below formula for OnChnage property of Quality.
If(
QAInput_2.Selected.Value = "Rejected",
UpdateContext({varProductionStatus: "Pending"}),
UpdateContext({varProductionStatus: PVInput_2.Selected.Value})
)
For patch I used
Production: If(
_Gals.QAInput_2.Selected.Value = "Rejected",
{Value: "Pending"},
_Gals.PVInput_2.Selected
),
Quality: _Gals.QAInput_2.Selected,
Could someone please hep me with this requirement or give me an idea how to do it.
Thank you so much in advance
