Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Add times

Hello everyone

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 🙂

Frequent Visitor


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.

Super User
Super User

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.

Helpful resources

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,749)