Power Automate. Delete from parent and child list using ID from parent list
I have a Tasks list in Sharepoint with fields like ID, priority and deadline. I also have a TaskActions list with the people to whom the task has been assigned. The Tasks list is like a parent list. The TaskActions list is like a child list.
The ID of the task is a lookup field in the TaskActions list and is called TaskID.
I need a Power Automate Flow or logic app that retrieves the ID of tasks which had a deadline more than 6 weeks ago.
It then deletes those tasks from the TaskActions list then the Tasks list.
I’ve used GetItems to retrieve the tasks, but my Flow is failing to retrieve the TaskID possibly because it’s a lookup field.
how we can implement power automata when if any file exist in adls we need to send mail [email protected] with attachment
Child Activity: