Unanswered

Updating a SP list when a different SP list is updated

(0) Share

Report

Posted on by cassiaposey

Hi, I am trying (unsuccessfully) to add onto a manually triggered flow that we have. The current flow is manually triggered because we only want it to run on a specific column change not on every change. Currently the flow just sends and email.

What I want to do is update 3 columns in a completely different list. The problem that I have run into is being able to call out the correct List Line to update since they have different ID #'s.

My process and flow is: Customer inputs information in List 1 - this information is used to create a list item in List 2.

When List 2 is completed I want to take some of the data in List 2 and update List 1.

I have added a number column to List 1 that is being updated with the ID # from List 2.

From reading through here and the rest of the internet it appears I need to do an array and filter - but I haven't been able to accomplish this and don't know very much about this feature.

Is there any help anyone can offer on this. I can provide screenshots but I am not sure which ones will be needed so I will hold off on that. Thanks

Categories:

Business Process Flows

All responses (2)

Answers (0)

cassiaposey 2 on at

Like (0)

Report

Re: Updating a SP list when a different SP list is updated

Hi @v-litu-msft
So right now List 1 is manually added with the following columns -

This information is then input into List 2 via a "When an item is created" Flow - After the new item is created in List 2 a SO Ticket # is automatically generated via Flow based on the ID of List 2 - Flow is then used to Update List 1 with the SO Ticket # and Status.

In both Lists I have a column called Status and Resolution. After the SO Ticket is marked complete in List 2 I would like a Flow to Update List 1 with the Status, and the Resolution.

In List 1 I have added a column "Increment Number" that is updated with the ID from List 2.

The problem I am having is when I do a "Get Items" or "Get Item" flow is asking for the ID of List 1 and List 2 and since they don't have the same ID's I'm getting stumped.

I read about using an array but I don't fully understand how that works.

Thank you for any help you can provide.
v-litu-msft on at

Like (0)

Report

Re: Updating a SP list when a different SP list is updated

Hi @cassiaposey,

So basically, what you're doing is manually entering the data, and then updating it to List1, and then updating the list2, and then updating the List1 again, and that's the logic, right?

I don't quite understand the connection between list1 and list2 columns. If you simply update list1 and then update list2, it is enough to establish a Flow of sequential logic execution from top to bottom.

Did you have any questions about which step? If necessary, you can discuss the relationship between Columns in detail. Such as, after updating list1, which column will bring to list2, and which column will bring to list1 from list2.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community site session details

Updating a SP list when a different SP list is updated

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

Updating a SP list when a different SP list is updated

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates