
This may include overhauling my dataverse table, which is fine, as I am still trying to design this.
Every night, I have a flow that will run, that will show the total amount of cases an engineer took.
Table1
Name, Date, TotalCases
Here is an example:
User1,1/3/2023,4
User2, 1/1/2023,0
User1, 1/1/2023,1
User 3, 1/1/2023, 5
User2, 1/2/2023, 6
Something like that.
The table part I can work out later, but I need to find a way to add data to the table in this fashion:
My table has three columns:
Name
Date
TotalCases
This will run monthly, so for example, User1, will have multiple entries.
But I want to grab User1, go through all the rows that has a date within 30 days (I have this piece figured out), and then list it like the screen shot above:
Column labels will be the dates. but each row will be dedicated to the one user. and under each date there will be total cases taken.
I am stuck on how to build this first part.