I have two Sharepoint lists Parent and child.
Parent has a column "ID". It also has a date column "CompletionDate"
Child has a column "RequestID" which the powerapp populates with the ID from the parent.
How can I retrieve all the rows from the child list where "CompletionDate" has a value?
I have used Parse JSON on the parent and child lists and was hoping to put the results into a Get Items action in Power Automate.