Hello Experts,
I have one flow which sends data from SHarepoint List to SQL server. The issue is date filled correct but sometimes time values are in incorrect format.
my SP list Datetime columns are formatted to 24 hrs format , same format i want in SQL server but it send 12 hr format sometimes and sometimes it sends correct 24 hr format.
for example if the SP list time DateTime is : 5/26/2021 17:12
in SQL table it stores DateTime : 2021-05-26 05:12:00.000
This is the formula i am writing in flow to get the dates.
formatDateTime(triggerBody()['ActivityStartDate'],'yyyy-MM-ddThh:mm:ssZ')
do i need to change anything here , please advise. i will be very grateful.
