Hello,
I am having the following problem, I have created a Power Automate flow that should send to every individual an e-mail containing 3 HTML tables, which should look like this:
So basically the first one should show the overall value, the second is identical to the first one with the only difference that the each value is also split by the process criteria, and the third one should just show the MTD and YTD values.
The problem is that even though only the second table has the process criteria, the information from the 1st and 3rd is also split by the process. For example, the last table for a random individual has 2 lines for MTD and YTD because he has worked on 2 processes, instead of merging the info for both:
Also, my flow below:
And the array function (I used this : array(triggerOutputs()?['Output']) just converts my tables from string types to arrays otherwise I receive an error when running the flow. Is that the problem ? That I only converted one table instead of all 3 ? I just don't know how to do it individually for every one of them because all 3 seem to have the same name (Output).
Thank you in advance!
