Error in Creating Email notification 7 days before Due Date - using power automate

[Serendipity102]

I am creating with the following Objective: Send email to "assigned to email"  for all issues wit h "Active" status that are due within 7 days.

However i am having fialed Flow - which i dont know where it was coming from. I already tried a lot of check but it seems like i cannot see where the error comes from

 1. Recurrence 

2. variable for the 7 days 

3.  for the varReminderDate 

Expression: addDays(utcNow(), variables('varNumDays'), 'M/d/yyyy')

The date format is the same as the format in my SharePoint List "Due Date" Column (see screenshot of the column below )

SharePoint list column: 

Internal Name for the Due Date Column: 

Due%5Fx0020%5FDate

4. Get Items - Filter Query:  Due%5Fx0020%5FDate eq '@{variables('varReminderDate')}' and Status ne 'Close'

5. Error encountered: Flow run failed 

Does anyone know why am i encountering the error? 

Thanks! 

[CheckMate]

that's a tough one.

why not try creating a new column with calculated value to add the column created_date+7 = due date.

and then create a condition if Status = Active && due date is > utcnow()

     send an email

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution.
If you have found my response helpful, please give it a thumbs up.