Sort and delete non-existing Dataverse Items from Sharepoint List

(0) Share

Report

Posted on by Gematria

222

Hi.

I am looking to update a Sharepoint List with Dataverse Data using the Sharepoint Batch action in Power Automate.

I have no issues getting everything updated, and creating new items that are not already in Sharepoint is also working fine. However, I am having difficulties wrapping my head around deleting items from the Sharepoint Lists that are no longer in Dataverse.

My flow relating to the filtering etc. Currently looks like this, and was copied from a guide i found:

And I would like to have a third branch that filters everything that is in the Sharepoint List, but not in the Dataverse anymore.

I was thinking about creating 2 arrays with unique Keycolumns from both the Sharepoint Data and the Dataverse Data, and then comparing the 2 to find out which of the items in the Sharepoint Data is no longer in the Dataverse data, but I am not sure how to achieve this without using some Apply To Each and compare the individual items.

Can anyone point me in the right direction here?

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

grantjenkins 11,059 Moderator on at

Like (1)

Report
Re: Sort and delete non-existing Dataverse Items from Sharepoint List

You can collect all the IDs from your Dataverse Table then use a Filter array to identify the SharePoint List items that aren't part of your Dataverse Table.

For this example, I'm using the following Dataverse Table.

And the following SharePoint List. Note that I'm matching on Name to Title. You would likely have an actual ID.

We can see that Test 004 and Test 007 exist in SharePoint but not Dataverse, so these are the ones that should be deleted from our SharePoint List.

See full flow below. I'll go into each of the actions.

List rows and Get items retrieves the items from Dataverse and SharePoint.

Select extracts all the Name values into a simple array. Note that I'm using Text mode in the Select (see arrow on screenshot below).

Filter array returns items from our SharePoint List where the Title doesn't exist within our array of Names. This will give us the items that exist in SharePoint, but not in Dataverse - the items we want to delete.

Apply to each then iterates over each of the items we want to delete and uses Delete item to delete them. The expression to get the ID of the item we want to delete is below:
items('Apply_to_each')?['ID']

After running the flow, we can see the two items have been deleted.

Was this reply helpful? Yes No
Gematria 222 on at

Like (0)

Report

Re: Sort and delete non-existing Dataverse Items from Sharepoint List

Did not expect to get the solution handed to me like that 😄 Much appreciated!
It was the whole filtering I couldn't quite wrap my head around, but makes sense when I see it now.

Thanks!

Was this reply helpful? Yes No