Answered

DateTimeValue in text input

Like (0) Share

Report

Posted on 1 Nov 2021 22:52:54 by biancadevera

Is it possible to have DateTimeValue format (mm/dd/yyyy hh:mm:ss.fff AM/PM) in text input and save it as text in SharePoint list? I'm working on forms and would like to make this work.

I have the same question (0)

All responses (9)

Answers (1)

biancadevera on 03 Nov 2021 at 02:59:16

Like (0)

Report

Re: DateTimeValue in text input

Hi @WarrenBelz
Thank you for your input. I was able to achieve what I want to do here.

Was this reply helpful? Yes No
WarrenBelz 150,345 Most Valuable Professional on 02 Nov 2021 at 21:28:31

Like (1)

Report

Re: DateTimeValue in text input

Hi @biancadevera ,

My previous post showed the extent that you can format a label using the DateValue function. You can either save this back as Text or simply save the text input itself and get the full format.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
biancadevera on 02 Nov 2021 at 18:37:26

Like (0)

Report

Re: DateTimeValue in text input

Hi @WarrenBelz
Since Text box won't accept the datetime format I was trying to do, I'm thinking of this: Enter the date and time (example: Nov 3, 2021 1:15:56 AM) > store it on label where it will convert to mm/dd/yyyy hh:mm:ss.fff AM/PM (11/03/2021 1:15:56 AM) > Save on SharePoint list based on the data of label.

I was referring to Power App form. Sorry for the confusion

Was this reply helpful? Yes No
WarrenBelz 150,345 Most Valuable Professional on 02 Nov 2021 at 06:13:07

Like (0)

Report

Re: DateTimeValue in text input

HI @biancadevera ,

I am getting a little lost with what exactly you are trying to do here - the data is Text to start with and you want Text in SharePoint - also are you referring to MS Forms or the Power App Form?

Was this reply helpful? Yes No
biancadevera on 02 Nov 2021 at 03:05:52

Like (0)

Report

Re: DateTimeValue in text input

Hi @WarrenBelz
Is it possible to input it on Text box in Forms then stored the text in label (hidden) to save to SharePoint list?

Was this reply helpful? Yes No
Verified answer

WarrenBelz 150,345 Most Valuable Professional on 02 Nov 2021 at 01:22:37

Like (0)

Report

Re: DateTimeValue in text input

Hi @biancadevera ,

This turns the Text Box to Date/Time, but I tested the various formats (LongDateTime etc) and they will not convert further

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
biancadevera on 02 Nov 2021 at 00:59:19

Like (0)

Report

Re: DateTimeValue in text input

Hi @WarrenBelz , I want to use the Text Input not the label. Is this possible?

Was this reply helpful? Yes No
WarrenBelz 150,345 Most Valuable Professional on 02 Nov 2021 at 00:21:06

Like (1)

Report

Re: DateTimeValue in text input

Hi @biancadevera ,

This gets the current time format (and will save as Text in SharePoint)- is that what you are asking

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
biancadevera on 01 Nov 2021 at 23:39:03

Like (0)

Report

Re: DateTimeValue in text input

@RandyHayes @WarrenBelz @StalinPonnusamy please help

Was this reply helpful? Yes No