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?
Not Able to insert datetime field into SQL Table from PowerApp Form
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.
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 (
