Unanswered

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

(0) Share

Report

Posted on by 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!?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
jamesfisher 34 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
v-LilyW-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No