Power Platform Community Forum Thread Details

Hi. I'll try and keep it simple. I have variations of this flow working, but I'm not satisfied with the elegance of the instructions. I have a current flow that pulls data from an Azure group and populates a SharePoint list. If I re-run this flow, it will duplicate the list every time.

Solution 1

One way around it is to enforce unique values at the SharePoint column levels. The flow will fail when it hits duplicates in the list, but it still creates all missing items without duplicating the existing items. I can live with that, but it seems hacky.

Solution 2

I found another way to run the flow, and then run another action/step after to remove duplicates, though it was super taxing and took like 10 minutes to complete.

------------

Is there a a more elegant way to splice in a duplicate check (the azure group and the current SP List) before the flow starts feeding into the list? Is it possible to use a select and union scenario to check and remove duplicates prior to the flow firing results into the SP list?

I was using these as ideas but can't quite figure out if I can create a check. @DamoBird365

Efficient Union, Except And Intersect – Great Method - DamoBird365

Example, I tried to create a 'select' from the current SP list that gets fed from the flow and 'union' it with the filtered array results form the Azure group that it feeds from. Might be on the right track, but I'm slightly lost in execution.