Power Platform Community Forum Thread Details

Exclude items with multiple entries in SharePoint

Hey,

maybe a little complicated but this is how I would do it:

First Part:

Get all items of the list using the Get items action and just point it towards your list.

Initialize a new variable: An Array variable called Owners, leave its Value empty for the moment.

Add an Apply to each action and put the value from the Get items action in the * Select an output from previous steps" field.

Inside the Apply to each, use an Append to array variable action to append the Dynamic content Owned By to the Owners array variable.

Second Part:

Use a Compose action with the following Expression, to remove duplicates in your Owners array.

union(variables('Owners'),variables('Owners'))

Also, Initialize a new Integer variable called Count, set its Value to 0.

Third Part:

Use another Apply to each action to loop through the Owners array (Dynamic content "Outputs" from the Union Owners Array action).

In this Apply to each, make another call to SharePoint using the Get items action, but this time filter it like this:

Make sure item() is an Expression. Also, you have to use the internal name of your SharePoint column OwnerBy... In your case this could be something like "Owned%20By" instead of "OwnedBy"...

Filter Query: OwnedBy eq 'item()'

Below that, add another Apply to each and use the value from the above Get items action as it's trigger. Inside it, simply use an Increment variable action to add 1 to the Count variable.

Fourth Part:

Now for the last part. Use a Condition action outside, below the last Apply to each action and check if Count is less than or equal to than 1.

In the left "If yes" section (green / left) you can now continue building your flow. These are all entries that only occur once in your SharePoint list.

Important: Don't forget to add the last Set variable action to reset the Count to 0 at the end but still inside the "Apply to each - Unique Owners" Apply to each action.