@zeboatis
I kindly request to discuss the Power Automate Cloud topic within the appropriate category instead of PAD. Kindly refrain from raising it in PAD in the future.
Regarding your task, I've developed a cloud flow. Initially, I compile a list of tasks and compare their due dates with the current date plus seven days.
If a due date is earlier than the calculated date, I add the task details to an array. Finally, I convert this array into a table format and send it via email.

Expression used on If condition:
addDays(utcNow(),7)
Thanks,
Deenuji Loganathan 👩💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥
-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀. If you'd like to appreciate me, please write a LinkedIn recommendation 🙏