Power Platform Community Forum Thread Details

Our business uses a company wide Team to provide updates that everyone in the business has access to. Part of our process is keep track of your own daily tasks/ accomplishments and provide updates in what we call a End of Day report. Currently this process is done via a Sales force task item that each employee updates at the end of the day. A report is then run compiling everyone's accomplishments and sent out in an email.

My hope would be to replace the email with a similar solution where completed tasks can be aggregated and posted directly to a team channel.

Categories:

Using connectors

Hi @Anonymous,

Do you want to post Outlook tasks that were completed on Microsoft Teams?

Currently, we do have a trigger for Outlook tasks, when a task is completed. However, it can be used to monitor one specific task. If you want to monitor all the tasks automatically, please take the following flow for a reference.

I would use the following flow to get tasks that were completed, and completed date right equals to Today’s date.

It is triggered by a Button. You may change it to Recurrence so that it can trigger the flow automatically daily.

Add the action List all tasks.

Add a Condition to check tasks that Status is Completed, and CompletedDate is Today. Besides, for tasks that have not been completed, the CompletedDate field would be empty. We need to use the empty function to check if the CompletedDate field is empty or not, otherwise the code will return false.

The code could be configured likes below:

@and(equals(items('Apply_to_each')?['Status'], 'Completed'),equals(if(empty(items('Apply_to_each')?['CompletedDateTime']?['DateTime']),'',formatDateTime(items('Apply_to_each')?['CompletedDateTime']?['DateTime'],'yyyy-MM-dd')),utcnow('yyyy-MM-dd')))

Under the if yes branch, add the action to Post message to Microsoft Teams.

Image for your reference.