Sharepoint List

Question

I have two Shorepoint lists.&nbsp;&nbsp;&nbsp;1. Parent List&nbsp;2. Child List&nbsp;&nbsp;There is a look up column on the child list for the name of the person from he parent list .&nbsp; Over time there is more names added to the parent list.&nbsp; Each year we need to delete the names of the parent list if they do&nbsp; not show on the child list.&nbsp; &nbsp;Any ideas how I would set up a flow&nbsp;&nbsp;

andrew hodges · Answer

james_fenna&nbsp;&nbsp;The Flow could use the REST API of&nbsp; the Child list to check there are no records matching.&nbsp;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.&nbsp;&nbsp;https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-lists-and-list-items-with-rest&nbsp;More of a sign post than a solution.&nbsp;

james_fenna · Answer

Andrew Hodges&nbsp; Thanks for your reply, I will have a look into this&nbsp;&nbsp;

Forum Discussion

Sharepoint List

Share

Resources