Jan 24 2022 12:28 AM
Hi
I want to use SharePoint to log sports activities for my swimcoaches.
They need a column where they can store values from test sessions, and the format should be:
Minutes, Sesonds, Hundredths, just like you can in Excel with MM.SS,00.
Can this be achieved? I don't know which clumn format to chose, and I'm guessing I need to format via JSON?
Jan 24 2022 02:46 AM
Jan 24 2022 02:55 AM - edited Jan 24 2022 02:56 AM
@jensjakobsen1966 there's no time-only column type in SharePoint so to keep things simple just do this with a single line of text column. Then you can have a Power Apps customised form to add in the numbers and combine them into the final time as shown on the attached video.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Jan 24 2022 04:08 AM
Jan 24 2022 04:08 AM
Jan 24 2022 04:25 AM
@jensjakobsen1966 I didn't split anything, they are just 3 text input fields and there are the 2 columns from the SharePoint list. I combined the values I typed into the field underneath and then used this value as the default for the TimeCompleted field which is what was saved to the list.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Jan 24 2022 05:01 AM