
Hello,
I've had a look around but haven't found a solution so I hope someone can help me.
I have a modern Sharepoint list to log SARs which has a Date Reported column and a calculated column which shows the due date which is in 20 working days from the Date Reported. I would like to schedule reminders for 7 days and 3 days before the due date however I am not given the option to select due date and believe this is because it is a calculated column. I'm happy to be corrected if this is not the case. I have followed a tutorial and have successfully set up the emails but can't work out how to either:
a. use the calculated Due Date column or
b. use the date reported column and add the correct amount of days
I'm a quite basic user but definitely willing to learn.
Can anyone help me please?
Thanks in advance.
Please show your flow.