Answered

Microsoft form to Sharepoint Calendar list event

(0) Share

Report

Posted on by MSherburne

Hello,

I'm trying to build a form using the base Forms program, not Pro, where individuals can input a date and a time to schedule an event. The date is acquired using the date prompt, but the time is acquired through a text prompt asking for input in HH:MM format. From there I can get the outputs to go through an approval process and once approved the outputs are used to create an item for my sharepoint calendar. So far, it correctly outputs everything except the time. The time will output into my Sharepoint calendar 4hrs earlier than requested (i.e. an event for 08:00am to 12:00pm will schedule for 04:00am to 08:00am).

Without having Forms Pro and the functionalityto ask for specific time inputs, how can I fix this time discrepancy?

I have the same question (0)

All responses (3)

Answers (1)

Craig Stewart ABZ 959 Super User 2024 Season 1 on at

Like (0)

Report

Re: Microsoft form to Sharepoint Calendar list event

I would first your timezone settings on SharePoint and Office first
https://myaccount.microsoft.com/settingsandprivacy

OR

From my Microsoft 365 profile> click Update profile >How can I change language and regional settings?

Then click "here"Then Language and Region and modify or set your timezone and region in there

I had a similar issues when building a Power App and posting times, it turned out to be the long winded approach I've detailed here. Hopefully that should fix your issue.

If not you could look at the AddHours() or AddtoTime expressions to force -4 hours to your output

Was this reply helpful? Yes No
MSherburne 4 on at

Like (0)

Report

Re: Microsoft form to Sharepoint Calendar list event

While I can adjust my profile settings and get the time to show correctly, other end users still see the incorrect times posted to the calendar and it's not feasible to have them all adjust their settings. I don't have the permissions to adjust the site time zones, so I'm looking for a workaround in the mean time that adjusts the output to the calendar.

Was this reply helpful? Yes No
Verified answer

Craig Stewart ABZ 959 Super User 2024 Season 1 on at

Like (0)

Report

Re: Microsoft form to Sharepoint Calendar list event

If the 4 hours are consistent for all users then we can work around it by using AddHours

addHours(concat(outputs('Get_response_details')?['YOURDATERESPONSE'], 'T', outputs('Get_response_details')?['YOURTIMERESONSE'], ':00Z'), +4)

That will add 4 hours to your originally entered time.

Was this reply helpful? Yes No