Using Flow to update from one SharePoint List to another SharePoint list with matching fields

[Ruenells]

I have searched and seen that this question has been asked before, however I am new at using Flow and need some help.

I have a list called CounterMeasures that the following columns:

• Segment
• Modality
• KPI
• Actual
• Target

I have another list called Heatmap which has the same fields, where I am having the issue is that I need to have the first three columns match exactly in both lists before you update the Actual and Target to the Heatmap list.

So they basically update/create an item and if the Segment, Modality and KPI match in the Heatmap list it copies over the content in the Actual and Target to the Heatmap.

I dont know how to ensure that match works and i need to figure out what I am missing.  I would really appreciate someones help.

Thank you in advance.

Dorinda

[Brad_Groux]

You would Add a condition to a flow, specifically an and condition with multiple lines. See the Use expressions in conditions to check multiple values documentation, and this example: 

Be sure that both of the SharePoint Lists have the desired columns in both of them added to their default List views. In the Update item step, you'd pass the non-matching columns.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Ruenells]

I did exactly that and it still isn’t working

[Brad_Groux]

If you could provide an expanded screenshot of your Flow and steps, and of any detailed error messages you're receiving we could likely better assist you.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[gamoraes]

Hi @Ruenells 

The flow that you need must follow this steps:

1 - Trigger when the List 1 item was modified

2 - Get itens from list 2 filtering by the fields of list 1(with OData), if the columns has the names that you post paste the expression below inside Filter Query

((Modality eq '@{triggerBody()?['Modality']}') and ((KPI eq '@{triggerBody()?['KPI']}') and (Segment eq '@{triggerBody()?['Segment']}')))

3 - Update all itens found

See the magic 😄

If you have any doubts feel free to post here

[Ruenells]

[gamoraes]

Hi @Ruenells 

You use the OData filter?

If yes, you don't need the condition, otherside your 'Get Itens' will bring all itens of Heatmap list, this will undermine your performance and you will have troubles when your list has more than 5k itens, but works too

[Ruenells]

In your screen shot your Get Items is taking from List 1 is that correct shouldnt it be taking from List 2?

[Ruenells]

I am trying but when I use the expression you provided and the Dynamic Content shows up it is only pulling from List 1 and the fields it is showing is saying Modality Value not Modality so it is failing.  However, I know those fields that I put before are correct.  And am I supposed to be pulling the data from List 1 or List 2?

[gamoraes]

---

@Ruenells wrote:

In your screen shot your Get Items is taking from List 1 is that correct shouldnt it be taking from List 2?

---

In my case i did a list to test, the correct is get from List2

[gamoraes]

---

@Ruenells wrote:

I am trying but when I use the expression you provided and the Dynamic Content shows up it is only pulling from List 1 and the fields it is showing is saying Modality Value not Modality so it is failing.  However, I know those fields that I put before are correct.  And am I supposed to be pulling the data from List 1 or List 2?

---

You can put the expression I've provided, remove the dynamic fields and put the correct fields, one point of attention is the field names in List2, if they aren't the same as the ones I put you need to change, you could post here a print from the execution history?

[Ruenells]

I am getting this error when I run this

[Ruenells]

The fields in both lists are the same so I dont understand why it is only letting me see the values of the fields from either list rather than the correct field?  I already posted the screenshot of the fail.

Here is a shot of the dynamic information that it is pulling from List one it is not even showing me the fields from list 2

[gamoraes]

The name of column in Heatmap isn't Modality, open the List Configuration and open the column, in the url you will find the correct name like this:

https://quickedit.sharepoint.com/flow/_layouts/15/FldEdit.aspx?List=%7B30B35D40-7EAE-4EB6-8562-D873F...

---

@Ruenells wrote:

I am getting this error when I run this

---

[gamoraes]

@Ruenells wrote:

The fields in both lists are the same so I dont understand why it is only letting me see the values of the fields from either list rather than the correct field?  I already posted the screenshot of the fail.

Here is a shot of the dynamic information that it is pulling from List one it is not even showing me the fields from list 2

---

It's right, you will only see the field from List2 below the action 'Get Itens'

[Ruenells]

Ok fixed that and it ran successfully however it didnt update anything in list 2.

[gamoraes]

---

@Ruenells wrote:

Ok fixed that and it ran successfully however it didnt update anything in list 2.

---

Can you post a result from 'Get Itens' from List 2? Please open the Show More to we see the used OData 

[Ruenells]

Here is the filter query since it didnt show in the screen shot

It looks like it only took the Segment not the rest

[gamoraes]

---

@Ruenells wrote:

Here is the filter query since it didnt show in the screen shot

It looks like it only took the Segment not the rest

---

Remove the Segment ant put Segment Value.

One thing that can make visualization and change easier is to create the Compose  action and put the value in there, and then at the place of the fields you would put the output of Compose action, like below,:

[Ruenells]

I am confused as to why you want me to replace the field that it pulled correctly it was the KPI and Modality that didnt get queried?