Hello,
I wish to send up a report that is emailed at the end of each week that has the following information:
Tenders submitted this week:
Based on the Bid Status = 'Submitted' and the Submitted Date being a range of the past 7 days.
Tenders to follow up:
Based on the Bid Status = 'Submitted' and the Submitted Date being the week prior to the last 7 days.
Tenders received this week:
Based on the Created Date being a range of the past 7 days.
I know how create the scheduled flow and to get the data into an email and send it, and I have figured out how to collect the data for the past 7 days, what I can't figure out is how to get information for the Tenders to Follow up (how to subtract 7 days from a date 7 days ago).
I also don't know if I can collect all this data in one flow. Would I need to create child flows, or could I branch the flow somehow?
Any direction would be greatly appreciated.
Regards,
Bron

Report
All responses (
Answers (