cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
santosh910
Frequent Visitor

Issue with Calendar Event in Flow

Hello Team,

 

Eagerly looking forward for your inputs and help!

 

My list has Interview Date, which is Date & Time Type, now I am sending the data from PowerApp to the List, which when modified will trigger the Calendar Event.

 

I am using Flow - When an existing item is modified.

 

As you can see the flow is executing fine, but the input data that I am getting in the flow is not having the Time values, only the Date is flowing. Please see below in the image for Start Time & End time. 

 

The formula that I am using in the PowerApp to compute the Date & Time is below. Hrs and Minutes are dropdowns.

 

DatePicker1.SelectedDate + Time(Value(Hrs.Selected.Value), Value(Minutes.Selected.Value), 0)

Kindly assist me with this, now all the events are getting triggered at 00:00 hrs. Also, one weired thing that I observed is the Interview Date is capturing 1 day less and 1 hour less, whereas the date is correct in the Calendar invite, any ideas why?

 

Event_Issue.JPGd

3 REPLIES 3
RobElliott
Super User
Super User

Hi @santosh910 could you post a screenshot of the steps in your flow so we can see what might be happening. Thanks.

Rob
Los Gallardos

@RobElliott Thank you for looking into this.

 

Here is a 3 step flow that I am using.

1. I am modifying the list via PowerApp, i.e inserting the interview date/time, interviewer details.

2. To ensure that the change is made via app, I am passing another value to a column FromApp, which if it is Yes, flow will branch.

3. Trigger the event creation

4. The problem here is as I mentioned in my original post, the time values are not flowing into the Flow.

5. Here are the properties of the First Interview Date column from list

Capture3.JPG

 

The Flow

 

Capture1.JPGCapture2.JPG

I think you would be better to have separate columns for the start and end date/time otherwise the event doesn't know how long it's going to last. When the StartDate and EndDate columns ar emodified in my list it creates the event successfully in Office 365 Outlook.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

0-SharePoint Date and Time columns0-SharePoint Date and Time columns1-Create Event1-Create Event2 - Calendar result2 - Calendar result

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (3,779)