Forum Discussion
Overview of completed tasks per day and who completed them
Hello Sandy, I hope you had a nice relaxing holiday. Thank you for your detailed answer, unfortunately I'm still at the very beginning and don't quite understand it yet. I've now tried to recreate your screenshot with my data, but I can't select or enter a name for the array variable, I probably did something wrong before? Can you look at that again and maybe paste your whole skein as a picture.
You also write that I should look at the output from the filter array, how can I display these? Many Thanks
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
Hi Sandy,
Thank you for the explanations, that definitely helps me a bit. Regarding JSON, yes, I have to and want to learn a lot more about that, but I'm a bit lacking in the approach. I've recreated your example flow and unfortunately I don't see a username, the output is always "zero". I looked at the output as you explained it, but I can't find my error, unfortunately I can't find the output of "Get user profile" either
What am I doing wrong?iTems looks like that by me:
items('Auf_alle_Anwenden')?['completedBy']?['User']?['id']I noticed another problem, all solved tasks are then output, but only those that have been added since the last execution of the task should be output, or if I would always run the task early in the morning, only the tasks that were solved yesterday.
Thank you for your patient help with a beginner.
I found my misstake, so i become now the User who completed the Task.
So only is open, how i can only the completed Task from yeasturday and not all completed Task.
So i think, i use a second "Filter array" With value and completed DateTime, but how can i say here "Yesterday"?
Thank you for your Help
