Use Case
I have an existing SharePoint Online (SPO) list where users enter a Date (no time) and indicate their work status (telework, in office, etc). I have a second list that with a meaningless title field and a date column that indicates corporate-recognized holidays. I need to produce email notifications according to the following schedule:
- Monday, Tuesday, and Wednesday: Send a notification at the scheduled time with an HTML table that includes the following work status data:
- Date
- Employee Name
- Work Status
- Thursday: This notification should provide the same data as Mon-Wed, but must ALSO include records for Friday
- All dates: if today is represented by Day 0 and tomorrow is Day 1, when Day 0 is followed by a corporate-recognized holiday, the notification should include data from Day 0 and Day 2.
Issue Description
I think I've figured out most parts of this, but there's a step where I Get Items from the SPO holidays list, then I want to see if my variable TOMORROW exists in the holidays list. I'm attempting to filter the holidays list using the TOMORROW variable and if I add a compose step, I can see that it is correctly grabbing the dates in the format I expect.
Next, I'm trying to get a boolean using a Condition. When I add the Condition, PA automatically creates a "For Each" condition, so I'm getting multiple outputs from this step in the flow where I really only want or need one: either TOMORROW returns a hit in the holidays table or it doesn't; the fact that there are multiple working days to check is irrelevant; if TOMORROW is a holiday for Tom, it's a holiday for Jane.
Screenshots:
Flow Outcome
In this flow, if TOMORROW has a hit in the holidays list, I'm successfully activating the True condition, but it loops for each person's work status submission and that's no good. I need to get to a table that combines all of them for the reporting requirement on that specific day of the week.
I have another workflow that reliably produces the table I need:
Try as I might, I cannot get this same workflow to produce a table on that conditional flow. Any idea what I'm doing wrong here?
