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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!