Changing Status when form saved

[chris_young]

I have an issue I'm trying to work through and any help would be appreciated.

I have a situation where only one user can change the status to Confirmed, but other users can come in and update the record after it has been Confirmed. I need to change the status from Confirmed to Pending, if a Confirmed record is updated by any user. 

I think I need this on the Save OnSelect before the actual submitform command. I'm trying the unsaved keyword and using that to switch the status, or at least that is what I'm thinking. I can't get anything to work so I'm coming here for advice. Thank you so much. 

This is what I am trying right now, but I'm sure I am wrong. I have email notifications and submitform after this, as I want the new status to change first and trigger emails.

If(User().Email<>"email1" Or "email2" & DataCardValue17_1.Selected.Value = "4 - Confirmed",
Patch(
    BIS_CUSTOMER,
    {ID: Gallery7.Selected.ID},
    {Request_x0020_Status:{
        '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
        Value:"3 - Pending"
        }
    }
),"");

[WarrenBelz]

No problems @chris_young , sometimes you need to pull things apart and keep building them back until you find the broken bit.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item.

[chris_young]

@WarrenBelz 

I have another question which relates to this:

If(User().Email <> "email1" ||

User().Email <> "email2" &&

DataCardValue17_1.Selected.Value = "4 - Confirmed",

Patch(BIS_CUSTOMER, {ID:Gallery7.Selected.ID}, {Request_x0020_Status:{Value:"3 - Pending"}}));

This works for changing patching the field correctly but it does it in all true or false cases. I have removed all the other code so I can focus just on what I have above. When I replace my email in email1, it still patches the field. I have added a label to validate User().Email is indeed showing as me and that's the value populated within the If statement. I have tried putting DataCardValue17_1.Selected.Value in the Else space, but it always triggers the true and patches.

Update:

I did some other testing and the If statement works fine when I remove the Patch. If I replace the Patch with Navigate(Screen1) it will or won't navigate depending on the outcome of the Logical Test in the If statement. With the Patch statement it appears to always execute that regardless of the Logical Test results. 

[chris_young]

Got it, for some reason had to replace || with Or and that fixed it. 

[WarrenBelz]

Good to hear @chris_young 

I am in a different timezone I suspect and just got to this.