Submit Form - Update two different SPO Lists if Field is specific Value

[lardo5150]

Now sure how to do this.

Here is my App.

When we click submit, all this information is submitted to the SPO Lists Assignments.

The time is updated with this formula:

DateValue1.SelectedDate +
Time(If(AMPMValue.Selected.Value = "PM",12,0) +Mod(Value(HourValue1.Selected.Value),12),Value(MinuteValue1.Selected.Value),
0
)

This is all working great.

What I would like is for the App to make the exact same update, in a different SPO list.

Engineers.LastCritAssigned

Only if the CaseType is Critical.

I dont think I can do it here, but thought maybe on the Submit button?

I would assume I would need an If statement there, but how do you make the update?

[RandyHayes]

@lardo5150 

You definitely don't want to do it on the submit button...that is before the data is submitted, how would you know if it was successful?

This should be done in the OnSuccess action of your form.

Example formula would be:

If(Self.LastSubmit.CaseType = "Critical",
  Patch(Engineers,
    {column: Self.LastSubmit.column}
  )
)

This would create a new record in the Engineers list and set the column specified to the value that was last submitted.

I am not clear if you are attempting to create a new record or update an existing, so the above is just to create.  I'd need more information to suggest further on updating an existing.

I hope this is helpful for you.

[lardo5150]

Let me see if I can do this from my phone lol.

Assignments spo list is where we log the cases.

The engineer spo list holds all our engineers data, including total count of cases, total count of critical cases, etc.

So we are UPDATING a record.

So on the submit of the edit form, we are creating a record in assignments.

So want I want to do is if the case type is critical take the same update of time you helped me with and update the engineer.lastcritassigned field for that engineer that matches the assignments.assignedto field.

Does that help?

[RandyHayes · Accepted solution]

@lardo5150 

So in that case, you want to lookup that record in your formula.

Example:

If(Self.LastSubmit.CaseType = "Critical",
  Patch(Engineers,
    LookUp(Engineers, somecolumninEngineers = Self.LastSubmit.AssignedTo),
    {lastcriticalassigned: Self.LastSubmit.column}
  )
)

By the way...pretty good from your phone!  I always have a hard time with the forum from the phone.

[lardo5150]

Ha thanks!

Ok let me try this tomorrow.

[RandyHayes]

@lardo5150 

Sounds good!

[lardo5150]

That was it!  THANK YOU again!!!