Power Platform Community Forum Thread Details

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

Categories:

Building flows