Power Platform Community Forum Thread Details

Hello

I have made a Power App to record time. Due to my fear of records, I have used a Sharepoint list with the following structure

It goes all the way to Project 6, though the use of anything beyond 2 is unlikely.

At the end of the month, I'd like to collect the hours worked for each person for each project. Is this possible, or should I go back to the drawing board?

I imagine a field called "Collated" being moved from no to yes on completion so only new records are used. Something that runs on the last Friday of the month, which I can handle -> Get items Collated eq false -> For Each user ?????

Image of the app