Update changes between two SharePoint Lists

Question

I have two List as belowone for Ticketing and another for Test Ticketing. I need to ensure that if I update a specific customer's information in the Ticketing list, the same changes are reflected in the Test Ticketing list. If the record does not exist in the Test Ticketing list, it should be created as a new entry.So i created flow as below&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;tested the flow and found that item creation was not working

narasimaperumal chandramohan · Answer

Mihiranp&nbsp;
Alternatively, you can fulfill this requirement with few steps. Check and let me know if this works for you.1)Following a trigger'When an item or file is modified'2)Use the 'Get Item' and Set the Site Address and List Name for Test Ticketing list, In the Filter Query field, enter the condition to match the column in Test Ticketing list with the Ticketing list.
Title eq 'triggerOutputs()?['body/Title']'3)Add a Condition which verifies whether the length of the retrieved items from SharePoint is greater than zero. If it is, it updates the existing data in the SharePoint list; otherwise, it creates a new item.
length(outputs('Get_items')?['body/value'])

&nbsp;
If this solution proves helpful and resolves your issue, kindly consider marking it as accepted. Doing so will aid others who encounter similar challenges in the future.Regards, NarasimaPerumal ChandramohaMicrosoft MVPApps4.Pro - Trusted Office365 T2T Migration partner. Migrate Exchange, SharePoint, Microsoft Teams, Stream, Yammer, Power Platform between tenants.Product Specialist - http://www.apps4.pro/

mihiranp · Answer

NarasimaPerumal ChandramohanI have created the flow as above but facing an error once the item creating&nbsp;this is my get item filter&nbsp;this my conditionlength(outputs('Get_items')?['body/value'])&nbsp;greater than zero

narasimaperumal chandramohan · Answer

Mihiranp&nbsp;
The 'Create item' action should not be nested within the apply to each loop. I observed that you've dynamically used values from the 'Get items' action to create the item. However, you should incorporate values directly from the trigger 'When an item or file is modified', since it is the new item.

mihiranp · Answer

NarasimaPerumal Chandramohan&nbsp;&nbsp;Hi,When updating an item in the main list, a new item is created successfully in the second list if it doesn't already exist. However, if the item already exists in the second list, a new item is created instead of updating the existing item&nbsp;&nbsp;Duplicate record&nbsp;

narasimaperumal chandramohan · Answer

Ensure that the 'Get item' action includes a filter query based on a unique field present in both lists, such as full name or ticket number. This helps to verify if the item already exists in the second list and allows for updates to be made accordingly.If so , please provide a screenshot of the 'Get items' action with all fields expanded.

Forum Discussion

Update changes between two SharePoint Lists

5 Replies