Delete SharePoint Item with same ID of other Sharepoint List Item

[bmagalhaes]

Hello all. I have made a flow that duplicates a list, but know I want to delete an item, whenever it is deleted in the "main" list. I am having troubles with this. Can you please help?

[bmagalhaes]

[Anonymous]

Hi @bmagalhaes ,

What happens when you execute the flow? 

Do you get any error messages?

[bmagalhaes]

Hello @Anonymous , no sir. The flow is tested and no error messages are shown.

[Mira_Ghaly]

@bmagalhaes 

So assuming the 2 sharepoint lists have the ID columns in Sync then what you need to do is to use Filter Query on Get Items to get the item from the second list as below then loop and delete

[bmagalhaes]

@Mira_Ghaly 

Thank you very much for your reply, but it is still not working, perhaps I'm doing something wrong. Here it is the current status:

[Mira_Ghaly]

@bmagalhaes 

You need to remove the condition now as it is not longer required.

Also can you explain what is the error you are getting now?

Also wanted to confirm is the 2 list share the ID as the common identifier?

[bmagalhaes]

@Mira_Ghaly 

I'm not getting any error, but the solution isn't working.

Yes, both tables share the same ID since one is copying the inputs of the other.

[Mira_Ghaly]

@bmagalhaes 

But the ID column is auto-generated so they might not be identical, can you identify another column which is identical.

[okeks]

As Mira_Ghaly said you can't use the default ID to compare list items between 2 different lists as they are system generated and can be different between the lists, also if the rest of the column contents are equal.

If you don't have another column with a unique value then you might want to create a synthetic one and hide that in the view from the users.

[bmagalhaes]

@Mira_Ghaly @okeks 

Now I understood, I can't use the systems ID to compare tables. For now, I don't have any other field that can be unique, what do you suggest me to create when you talk about a synthetic one?

Thank you both for your help.

[okeks]

You could use something like concat("ID_", guid()) and write that in a column e.g. ItemID.

Of course you need to make sure that this column also gets copied when you transfer the data to the second list.

To avoid confusion of users I would remove this column from all views in Sharepoint.

[Mira_Ghaly]

@bmagalhaes 

I would suggest to create a new column and call it MainID that keeps that main list Id in the sub list it would make it easier while deleting so your query can be 

MainID eq ID

[bmagalhaes]

@Mira_Ghaly @okeks 

I did what you suggest and create an ItemID that goes on both tables, guaranteeing that I can relate the same fields in the Power Automate. However, I'm not seeing the the ItemID on dynamic fields when I want to do the eq.

[okeks]

The problem is that Power Automate caches the provided fields at the time you create the trigger or action.

There are 2 possible workarounds:

1) Delete the original trigger or action and recreate it (makes a mess with existing dynamic links)

2) Use another field from the dynamic content, cut the dynamic content from the filter line and then use the Expression function to insert and edit the field to the one you need.

[bmagalhaes]

@okeks 

Thank you for help, I have tried but did not work: 

item('ItemID') 

Any suggestions? 

[okeks]

Have you already tried this?

1) Delete the original trigger or action and recreate it (makes a mess with existing dynamic links)

I know it is sometimes hard work, but you could also first try to copy the flow an try it out in the copy.

[bmagalhaes]

@okeks 

Yes, sure and did not work either.

[okeks]

Please show what is inside this function.

Most likely the issue is that the function needs to be set between apostrophes.

e.g. ItemID eq 'item(.....)'

[bmagalhaes]

@okeks 

The function I tried is : item('ItemID')