update a list item in any site - finding a common ID

by chris.baird » Wed Jun 14, 2017 3:33 am

Related to viewtopic.php?f=24&t=1980

I'm using "Create a list Item in any site" to create a copy in listB of a list item in listA. I need to figure out how to match up IDs for the update of the listB item when the original listA item is updated. I have a columns (EEID) that matches in both lists as the ID #s will be different; the EEID is a text field with values like AAA1, AAA2, etc.

How do (1) I find the common ID to match my 2 items up for updating, and then use that in (2) the update a list item in any site action?
User avatar
chris.baird
 
Posts: 1
Joined: Wed Jun 14, 2017 3:24 am

by andrelima » Thu Jun 22, 2017 1:13 am

Hello Chris,
Thank you for getting in touch.
I apologize for the delay.

There are actually multiple ways to do it. The easiest would be to build a dictionary with the values from listA and use this same dictionary to either create or update the item on listB.

Here is an example of how I did it on my side:
image1.PNG
image1.PNG (7.22 KiB) Viewed 75 times


First I set a variable called EEID just to keep which item I want to look for.
Then I built a dictionary to use as properties for the next action.
image2.PNG
image2.PNG (6.19 KiB) Viewed 75 times


Obviously my lists are really simple with only a couple columns so you have to do it according to yours. You can create properties looking for the correct value and using our variable.
image3.PNG
image3.PNG (22.06 KiB) Viewed 75 times


Then is just a matter of adding the next action and setting the right parameters. Either for update list item or create list item.

Best regards,
Andre Lima
Plumsail Team.
User avatar
andrelima
 
Posts: 60
Joined: Wed Apr 19, 2017 2:06 pm


Return to Workflow Actions Pack for Office 365