You’re offline. This is a read only version of the page.
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 Selec
Sharpoint list : result on Sharepoint list
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:
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:
Set the Update property of the Date Time field data card to following:
Share
Report
All responses (
Answers (
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:
Within your flow, when you want to create an event in requester's Outlook calendar, please configure your flow as below:
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,
