So I have looked through other queries on this topic but can't find anything similar. If someone can point me to a post or if not if you can help on how I might approach this situation.
2 sharepoint lists
ListA and ListB
This is a manually triggered flow (will eventually use the powerapps trigger as it will be done from a button in powerapps but happy to just use manual trigger to get it working)
I want to pull in a subset of the items in ListA into ListB (subset is items filtered based on choice field in ListA).
When pulling in the items I want to compare ! so if the item already exists in ListB I want to overwrite (in case changes were made to the item in ListA) and if the item doesn't exist I want to add it into ListB.
and just to complicate things LOL there will be attachments to the items in ListA that will need to be brought in also !
Any help gratefully accepted
A few questions:
Hi Scott thanks for your response.
One more question - if an item already exists in List B, can it be deleted and re-added or does it have to be updated (so you can keep the version history, etc.)?
See my Flow below. If the item exists in List B, I update it, remove existing attachments and add attachments from List A. My condition checks to see if the item already exists. Let me know if you have any questions
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.