web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Create an event in the...
Power Apps
Answered

Create an event in the calendar based on the date and time of a form

(0) ShareShare
ReportReport
Posted on by 63

Hello,

I have an application for validation of absence requests, and I would like to add an event to the requester's outlook calendar automatically after validation via Flow.

My problem concerns the hours for the event.
For a whole day I like 8 am to 6 pm.

For the half day it depends on the column "Half day": No or AM or PM
If AM I would like 8 am-12noon
If PM I would like 1 to 6 p.m.

What do you recommend ?
>> a modification directly on Flow? (in this case how?)
>> On Form: I tried to change my datepicker to Date + Time Picker (and modify the Default of Time) but I have a big difference between the selected date and the date registered in my list) [Cf Image]
So how do you change the DateTimepicker by default?

Thank you


DatePicker SelecDatePicker Selec

 

Sharpoint list : result on Sharepoint listresult on Sharepoint list

Categories:
I have the same question (0)
  • Verified answer
    v-xida-msft Profile Picture
    Microsoft Employee on at

    Hi @Glaga ,

    Could you please share a bit about the data source used in your app? A SP List?

    Do you store the validation of absence requests into your SP List?

     

    Based on the issue that you mentioned, I think this issue is related to time zone. On your side, you should enable "Include time" option for date time type column in your SP List as below:

    4.JPG

    then when you generate a new app based on your SP List, the Date time column from your list would be decorated as a date time picker as below:

    5.JPG

    Set the Update property of the Date Time field data card to following:

    DateValue1.SelectedDate + Time(Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value), 0)

    Set the Items property of the HourDropdown box to following:

    ["00","01","02","03","04","05","06","07","08","09","10","11","12","13","14","15","16","17","18","19","20","21","22","23"]

    Set the Items property of the HourDropdown box to following:

    ["00","01","02","03","04","05","06","07","08","09","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","32","33","34","35","36","37","38","39","40","41","42","43","44","45","46","47","48","49","50","51","52","53","54","55","56","57","58","59"]

     

    In addition, you must make sure the Time zone setting and Locale setting of your SP Site have been set to same value as your local PC/machine:

    6.JPG

     

    Within your flow, when you want to create an event in requester's Outlook calendar, please configure your flow as below:

    7.JPG

    Within the "Create event (V4)" action, Start Time field set to following:

    triggerBody()?['Created']

    End Time field set to following:

     triggerBody()?['DueDate']

     

    Please consider take a try with above solution, check if the issue is solved.

     

    Best regards,

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 541

#2
WarrenBelz Profile Picture

WarrenBelz 434 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 289

Last 30 days Overall leaderboard