0

Is there a way of retrieving the created and modified time in Seconds and Milliseconds?

Currently in the SharePoint list it seems it only gives u the dates like this 2021-02-08 17:23. What I need is 2021-02-08 17:23:30:599. This is required as users can potentially add entries for the same customer etc.

The SharePoint List is connected to a Power App .

1

Milliseconds cannot be retrieved, but we can retrieve created and modified time in seconds. Create two calculated columns and use the following formulas respectively:

=TEXT(Created,"MM/DD/YYYY hh:mm:ss AM/PM")

=TEXT(Modified,"MM/DD/YYYY hh:mm:ss AM/PM")

Test result:

enter image description here

1

You can use below formula on label control to show the Created field in specific format:

Text(ThisItem.Created, "mm/dd/yyyy hh:mm:ss AM/PM")

OR

Text(ThisItem.Created, "[$-en-US]mm/dd/yyyy hh:mm:ss AM/PM")

Output:

enter image description here

Documentation: Text function in Power Apps


You can also add fraction of seconds like:

Text(ThisItem.Created, "[$-en-US]mm/dd/yyyy hh:mm:ss.fff AM/PM")

But for me, it always returns 000. So maybe SharePoint does not provide this information in Power Apps.

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.