REMOVE ITEMS FROM FIRST LIST

[Anonymous]

Hello everyone, I need your help please.

I have a power app.
On one screen I have an attached control for excel files and
I upload it to a sharepoint library and each of the elements contained in the excel table
It creates them as elements in a list.

On another screen I have an attached control for excel files and
I upload it to a sharepoint library and each of the elements contained in the excel table
It creates them as elements in a list.

What I want to do is remove elements from the first list if they exist in the second list.

[MarvinBangert]

Hi @Anonymous,

So, you are importing the data from Excel file into List B and before doing that, you want to check if that item already exists in List A and if it exists, you want to delete it from List A and create it in List B, correct?

Are you using "Apply to each" in your flow? If yes, are you running on each element from your Excel file? If yes, you can add a SharePoint action "Get items" and use the Filter Query to filter it on one or more values that you want to check and that are unique in List A:

You need to use the internal column name for the filtering. This site might help you with Filter Querying: Power Automate OData filter query with examples - SPGuides

This should return one or none item. Now you can use a condition to define what should happen, e.g. if it does find an element in List A, delete it from List A, otherwise just go on.

To check if the "Get items" returned one or none item, you can use this expression:

length(outputs('Get_items')?['body/value'])

This will check the amount of items returned (length), if it is 0, no item was found, if it was not 0, an item was found and you can use the SharePoint action "delete item" to delete it from List A.

Does this help you? Otherwise please give me some more information.

Best regards
Marvin

If you like this post, give a Thumbs up. If it solved your request, Mark it as a Solution to enable other users to find it.

Blog: Cloudkumpel
Join my User Group (German & English): Power Platform UG Cologne

[Anonymous]

Yes, I want to delete the items on the list A.

I share my flow:

The action Get Items is after the Create Item isn't it?

[Anonymous]

I added more actions to obtain items of both lists and than I can make a condition to compare both list isnt?

The correct way to do this comparation maybe can be body('Obtener_Elementos') contains body('Obtener_Elementos_2')

I had an error in my flow

I put body('Obtener_elementos')