Hi I am trying to insert datetime from powerapp into Azure SQL Database connected table using the form, below function I am using to insert from Update function but I am not seeing time getting formulated, for example I am seeing value as 2025/01/01 00:00:00.000 like this each time I insert value from the form, function that I am using:
DateTimeValue(Text(Now(),”[$-en-GB]yyyy-mm-dd hh:mm:ss”,”en-GB”));
Does anyone has any idea what is going wrong here?
Have resolved the issue, fix was the just delete the dataset connections and re-add and test the application the datetime insertion was working after that, not sure its a bug or something but it should be mentioned somewhere in MS Documents.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
8
Share
Report
All responses (
Answers (
