
Announcements
Good day, I have a sharepoint list with 3 columns that each have their own statuses. I want to sent an email if a status has not been changed in x amount of days. Each status has different amount of days before an email is sent.
For example, the open status will have an email sent after 7 days, in progress status will sent out an email after 30 days and etc.
I have done something like this before where I made seperate hidden columns which records the dates when each status was first changed. So when in progress is changed on july 10, the column records july 10 and calculates the x amount of days from that.
These hidden columns are updated using another flow automatically when a sharepoint item is modified.
However, since there are more then 1 column with status this time, I was wondering if there was another way to implement this, since my current strategy is extremely slow and chunky.