cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ruenells
Helper II
Helper II

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

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

31 REPLIES 31

Your segment column is a search, in my example I use this as a single text.


In OData the query must meet the documentation, to work correctly I will need you to give me the names and types of each of these 3 columns.

 

I will make an example for you and put here, so you can import and compare with your current flow


Did I answer your question? Mark my post as a solution!

Gustavo Moraes, o astronauta brasileiro do Flow!


I did your compose and it is reflecting the correct information I also updated all of the fields that I am needing to update with those compose fields and ran the flow successfully still not updating the list 2.  I am so lost as to why this is not working as expected.

flow8.png

tay calm, it's more complicated to work with query columns, I'll set the example and leave it as explanatory as possible for you, so you can quietly do something similar


Did I answer your question? Mark my post as a solution!

Gustavo Moraes, o astronauta brasileiro do Flow!


Thank you for your help I appreciate you guiding me through this.  It is not always easy.

@Ruenells 

 

I put here in attachaments the Flow,

 

I create one compose for each parameter, and put inside it the value of each colunm, like belowFlow 1.jpg

 

Flow 2.jpg

 

If you don't know how import an Flow you can see this here

 

W8 for good news!


Did I answer your question? Mark my post as a solution!

Gustavo Moraes, o astronauta brasileiro do Flow!


I click on the import button and it just spins not doing anything i swear this it out to get me.  Is there a way to view the file so i can replicate it?

 

Dorinda

This is the full print of flow, but i follow the steps that i put beforescreencapture-us-flow-microsoft-manage-environments-Default-cb223f09-131c-4e3e-ab6f-0798658a438c-flows-e218208f-453d-4021-8479-3bfdc9d73836-2019-05-23-16_16_01.png

 


Did I answer your question? Mark my post as a solution!

Gustavo Moraes, o astronauta brasileiro do Flow!


Rebuilt from scratch and it says it ran successfully but didnt update the list at all...any other suggestions?

Can you post the history of get itens here? Includind the OData and result?


Did I answer your question? Mark my post as a solution!

Gustavo Moraes, o astronauta brasileiro do Flow!


5.png6.png7.png8.png9.png10.png1.png2.png3.png4.png

@Ruenells   as we saw together we had some troubles with the OData , because the column have some spaces, and i don't know why it isn't working, but we had workaround this by using an condiction inside apply to each to ensure that the values will be the same.

Can you please mark the thread as solutioned?


Did I answer your question? Mark my post as a solution!

Gustavo Moraes, o astronauta brasileiro do Flow!


Thank you so much for taking the time to work through this. It really will be a time saver and I have learned a lot. If you ever need SharePoint help I am your girl!!

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,179)