Here's my flow:
After the Compose data ops, save and test the flow prior proceeding to Parse JSON data ops. Copy the output from the test of Compose data ops, as shown in screenshot below:
After copying output, proceed to next steps on screenshot below:
on the above screenshot - the first filter should be the default value of the filter query (replace AssignedTo with the equivalent column name on your list). you can add other filters accdg to your requirement - in my case i added Status ne 'Completed' to filter all pending and not started tasks on my list. you can also add filter on dates, etc.
re: above screenshot - i added this condition so that when filter status returns 0 (meaning no pending/not started status), no email will be sent to the Assigned To emails. This is necessary for scheduled cloud flows to prevent sending blank emails to recipients on defined schedule.
i downloaded the formatting style from this website - https://ryanmaclean365.com/2020/01/29/power-automate-html-table-styling/
There you go. Hope this helps!
