Hello,
I am probably not the first or last to bring this discussion to the community, but I could not find a similar post after a quick search. I have done research around "volatile" functions like TODAY, DATE, NOW and the issues with using them not being able to automatically update in Lists on Sharepoint.
I have many columns, but focus is on the column "Date Orig Email Sent" and the column "Status" with the value In Progress. My goal is to use a flow to send an email notification 7 days and 11 days after the DATE in the "Date Orig Email Sent" column if the "Status" is In Progress. I have tried to calculate days in a separate column using Today() - [Date Orig Email Sent], but as stated List will not update automatically. I have had other ideas of passing the data through different gateways (Power BI, Excel, etc) but this seems like something that I should be able to perform with less steps than that.
Does anyone have any thoughts? I set the flow with a 1) Recurrence (daily), 2) Get items from Sharepoint List, 3) Apply conditions to check if "Status" is In Progress and if date is 7 or 11 days after "Date Orig Email Sent", 4) Send formatted email notfications.
Any help or resources would be greatly appreciated.
Thanks.
