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

(0) Share

Report

Posted on by lardo5150 Microsoft Employee

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@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.

Was this reply helpful? Yes No
lardo5150 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@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.

Was this reply helpful? Yes No
lardo5150 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Ha thanks!
Ok let me try this tomorrow.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@lardo5150

Sounds good!

Was this reply helpful? Yes No
lardo5150 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

That was it! THANK YOU again!!!

Was this reply helpful? Yes No