Overview of completed tasks per day and who completed them

Hi Thomas1730 

Sure, I'm happy to provide more details.

About the array variable: Any time you wish to use a variable in Power Automate, you must initialize it before using it. This defines what type of a variable it is. I usually like to define any variables at the beginning of my Flow. So in this case, I'm suggesting that you add an "Initialize Variable" action to initialize an array called something like CompletedTaskArray, and define it as an Array-type. For example:

About viewing the output of the Filter Array step: By this I mean that after running your Flow, you can view the result of each action. After your Flow has run, you can click on it in the Run History on the "dashboard" page of that Flow, like so:

This will open a view similar to below, where you can see (hopefully) little green checkmarks on each step that completed successfully.

You can click on each step to see the details of its inputs and outputs during that Flow run. Here, I've clicked on the Filter Array action:

What I was referring to in my message was that if you scroll down through the Outputs section of the Filter Array, you can see all of the elements (e.g. planId, bucketId, title, etc) that are output from getting the tasks. This data is in JSON format, displaying each element name, and its value. One of those elements is completedBy, which contains sub-element user, which contains sub-elements displayName and id, as shown below. It's that id value that you can use to retrieve the user with the O365 Users action.

Learning to read JSON formatted data will be very helpful for you as you learn more about Power Automate, as basically everything is JSON underneath 🙂  

Here is my entire test flow...

Does this help you better...?

Sandy