Forum Discussion
Mihiranp
Mar 12, 2024Copper Contributor
Update changes between two SharePoint Lists
I have two List as below one 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...
Mihiranp
Mar 13, 2024Copper Contributor
NarasimaPerumal Chandramohan
I have created the flow as above but facing an error once the item creating
this is my get item filter
this my condition
length(outputs('Get_items')?['body/value'])
greater than zero
Mar 16, 2024
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.
- MihiranpMar 18, 2024Copper Contributor
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 itemDuplicate record
- Mar 18, 2024Ensure 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.