Hi!
I am attempted to create a flow which goes into my OOF calendar on my sharepoint site and gathers all the employees listed for the next day. I want this to run at 9am and send an automated email to the supervisor with the employees off for the next day, but ran into some issues with the dynamic input within the filter array action.
@and(
greaterorequals(adddays(utcnow(),1,'yyyy-MM-dd'),formatDateTime(item()?['EventDate'],'yyyy-MM-dd')),
lessorequals(adddays(utcnow(),1,'yyyy-MM-dd'),formatDateTime(item()?['EndDate'],'yyyy-MM-dd'))
)
This is what I am currently using but for some reason the email i get is just a list of all the holidays for the year. Anybody have any idea how i could fix this?
Thanks!