Hi @Logannm
I would do the following.
1. List task action
2. Compose action to create tomorrows date (with some good date formating)
formatDateTime(addDays(utcNow(),1),'dd/MM/yyyy')
3. Filter the retrieved tasks to avoid task which has no due date and are equal to tomorrow date
Input: are the "value" of the list task action (dynamic content)
Filter condition is in advanced mode with code
@and(not(equals(item()?['dueDateTime'], null)),equals(formatDateTime(split(item()?['dueDateTime'],'T')[0],'dd/MM/yyyy'),outputs('Compose_-_Tomorrow')))
4. Select action to create a nice array of certain value
Input:
body('Filter_array_-_Task_Due_Date_not_equals_null')Map:
| Title | |
| Due Date | formatDateTime(split(item()?['dueDateTime'],'T')[0],'dd/MM/yyyy') |
| UserId | item()?['_assignments']?[0]?['userId'] |
| TaskId | |
5. Apply to each loop to run trhoug each task to send the email/teams channel
Get User Profile
Send email
That works very fine 🙂
Final Email
Hope that brings it closer to what you want to achieve.
Please accept as solution if it will solve your challenges.
