Hello All,
Need your help
Not able able capture current date and time.
In powerapps I'm using "Set(Ctime,Text(Now(),DateTimeFormat.LongDateTime24))"
in the patch function I'm using
But in the sharepoint I'm able to see only current date is capturing not the current time
How to save current date and time value in sharepoint.
Solved! Go to Solution.
Hi @Anonymous :
Could you tell me:
Firstly,let me explain why you encounted this problem.
The point is TimeZone.The time in your App is the local time. When the time is saved to sharepoint, it will be converted according to the time zone set by your SharePoint Site. So the time you get is different from the time in the App.
Secondly,I have two soltuions:
Solution1:Modify the formla
RecordCreatedDate:DateAdd(DateTimeValue(Ctime),X,Hours),
Solution2:Change the TimeZone of your SharePoint Site
Site contents>Site Settings>Site Administration>Regional settings
Best Regards,
Bof
Hi @Anonymous :
Could you tell me:
Firstly,let me explain why you encounted this problem.
The point is TimeZone.The time in your App is the local time. When the time is saved to sharepoint, it will be converted according to the time zone set by your SharePoint Site. So the time you get is different from the time in the App.
Secondly,I have two soltuions:
Solution1:Modify the formla
RecordCreatedDate:DateAdd(DateTimeValue(Ctime),X,Hours),
Solution2:Change the TimeZone of your SharePoint Site
Site contents>Site Settings>Site Administration>Regional settings
Best Regards,
Bof
User | Count |
---|---|
161 | |
84 | |
68 | |
63 | |
60 |
User | Count |
---|---|
211 | |
146 | |
94 | |
82 | |
67 |