How to Delete a row from secondary list when deleted from main list

[jamesfisher]

I have already got a flow with 'When an item is created or modified' to add/update a secondary list using the Filter Query (in Get Items) for the 'identifier' of the individual list row. This adds new records or updates current ones successfully.

I now want to be able to 'delete' a list row from the main list and for it to automatically delete it from the secondary list - I'm struggling to figure this out as I don't have the same options/filter options available to me if I use the 'When an item is deleted' trigger

Am I going about this in the right way!?

[Hardesh15]

@jamesfisher  Store main list item ID in your secondary list then by using that ID in your filter query , you can delete row from secondary list.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh /Gopenly.in

[jamesfisher]

Thanks @Hardesh15 - I'm still struggling to get this to work. Here is my flow. The ID is brought across to the secondary list via the 'When an item is created or modified' flow to the AAA ID NO column (Field=AAA_x0020_ID_x0020_No_x002e_)

Have I missed a step or set it up incorrectly?

 

Secondary list  

[Hardesh15]

@jamesfisher  What is error message? And what is the type of your AAA...ID column?

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh /Gopenly.in

[v-LilyW-msft]

Hi @jamesfisher 

Please make sure you use the correct column internal name.

You can find the column internal name via List settings -> Click on the column name -> It’s at the end of the URL on the Edit column page, after ‘Field=’.

Then delete this item.

Best Regards.