Power Platform Community Forum Thread Details

Hi Guys

Im very new to power automate, so i apologies if my question has been solved before, and thanks in advance for any help im offered.

I'm trying to build a scheduled flow that sends out an email at the start of each month with a summary of major key items that will occur in that month. Because of the nature of my business (wine), most of the activities are very consistent throughout the years, however, schedules may change from year to year, hence most of the activities span across a range of when it could start.

What i thought would work is to create a list with the months as columns and use yes/no fields to indicate if said activity will be included in the given month. See screenshot below.

So this is where im stuck, in my head, I want to use a scheduled flow, to filter the columns by month, and then any items with a yes on it, take that item and build an email/ teams post around that, and even prompt the department/ manager in charge to provide more detailed information for that activity.

Let me know how i might be able to do that, or if there is a better solution to what im trying to achieve.

Cheers

Categories:

Building flows