I am working on an application to record arrival and departure times. I have two Sharepoint lists:
- one with the users
- one in connection with the first, which contains the time of day (morning, noon, evening, etc.), the time of the check-in, the day of the check-in, the person who checks in.
I would like to add to the application the total of hours spent during the day. I tried different approaches but without real success, in a gallery I start with:
Filter ('Table time';
IDRef.Value = DataTable1.Selected.ID)
to display the times corresponding to the user, then I am blocked for the calculation of the hours per day.
Do you have a working path? A solution ?
Thank you 🙂
Thanks for the explanation . I understand how to manipulate data with collections and how to work with it.
However, I found an error: Invalid argument type (Table). Expected text value.
In the end I have the data I want in collections but the value is a table and not a text or number or date value.
The addition of the RowNo is what allows this to work - You get a Table error when you do a lookup with the ".Hour" designation after? that should leave you with a single value.