You’re offline. This is a read only version of the page.
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
Used the below formula for OnChnage property of Quality.
Share
ReportIf(
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
Hello @scalca
Thank you for your reply,
I have tried to put the varProductionStatus variable in Default property of Production Dropdown
but if I select Rejected for one item. all other items are Changed to Pending.
Could you please tell me how to tackle this
#1
WarrenBelz
146,635
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
All responses (
Answers (
