Sharepoint List

%3CLINGO-SUB%20id%3D%22lingo-sub-1548156%22%20slang%3D%22en-US%22%3ESharepoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1548156%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20two%20Shorepoint%20lists.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20Parent%20List%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20Child%20List%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20a%20look%20up%20column%20on%20the%20child%20list%20for%20the%20name%20of%20the%20person%20from%20he%20parent%20list%20.%26nbsp%3B%20Over%20time%20there%20is%20more%20names%20added%20to%20the%20parent%20list.%26nbsp%3B%20Each%20year%20we%20need%20to%20delete%20the%20names%20of%20the%20parent%20list%20if%20they%20do%26nbsp%3B%20not%20show%20on%20the%20child%20list.%26nbsp%3B%20%26nbsp%3BAny%20ideas%20how%20I%20would%20set%20up%20a%20flow%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1548156%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

I have two Shorepoint lists.  

 

1. Parent List 

2. Child List 

 

There is a look up column on the child list for the name of the person from he parent list .  Over time there is more names added to the parent list.  Each year we need to delete the names of the parent list if they do  not show on the child list.   Any ideas how I would set up a flow 

 

2 Replies
Highlighted

@james_fenna 

 

The Flow could use the REST API of  the Child list to check there are no records matching.

 

For Each Parent (If the count in the Child List query = 0 ) then delete the parent. How to do it exactly I don't know. 

 

https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-lists-and-list-items-with-re...

 

More of a sign post than a solution. 

Highlighted

@Andrew Hodges  Thanks for your reply, I will have a look into this