I have spent a week 10 to 11 hours working with three diffrent AI's with out any resoult and though I try a human.
I have a sharepoint site with 2 list 1 is pT0 request the other pT0 calendar. Using power automated the manager would approve the date requested and would post the dates in the pT0 calendar ensure point. The problem having is that AI is not able to figure out why when a date is selected as a request why it is posting the day before. and in some instances it would posted the day before and the day of the request with a time as a prefix for example 7:00 p.m.. AI was able to remove the time prefix but still it is posting twice the day of the request in the previous day. Sharp point website was verified to be on the right region. Any assistance would be immensely appreciated
Honestly I really don't care about the prefix with a time any more. Exhausted. Just need it to post in the correct date.
@{formatDateTime(triggerOutputs()?['body/Start_x0020_Date'], 'yyyy-MM-ddT00:00:00Z')}
@{formatDateTime(triggerOutputs()?['body/End_x0020_Date'], 'yyyy-MM-ddT23:59:59Z')}
Shows two entry dates and the time no longer shoes. So If I requested June 6. I get June 5 and June 6 posted on sharepoint.