This is a long one. I have been looking for the solution for a while now.
My end goal: Send a weekly email with an HTML table containing list items that are a) from a "Location" choice column of more than one choice options and b) are less than or equal to "Next Maint. Due" date column plus 7 days.
I have gotten this to work with the choice column, but each time I try to do it with the time variable, something messes up.
I'd include screenshots, but I have made so many flows, I'm not sure which to start from...
Essentially this is what I have:
Trigger: Runs on Sunday every week>
Get Items>
Filter Array>
Select>
Create HTML table>
Compose>
Send email.
This works for the choice column. I have tried many flows to get the date to work, and the only time it has worked, I wasn't able to use an HTML table.
The location choice column options are:
GA-CS
GA-Safety
GA-Whse
SC-CS
SC-Whse
FL
I want to create flows for locations containing GA, containing SC, and containing FL. (So three flows, one email to send for each)
