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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Add a calculated tick ...
Power Automate
Unanswered

Add a calculated tick to the End DateTime of an Outlook calendar item

(0) ShareShare
ReportReport
Posted on by 100

 

EDIT:

Ok, I guess the error is there because my first argument in
addMinutes(outputs('EndB'),outputs('Differenz')) 

is wrong.

Not the output of "EndB" which is just a tick, instead I have to take
the original "items('Apply to all')['end']" value which is a string in DateTime Format.

 




Hello, I am stuck at one point in my flow.

I calculate the difference of two Outlook calendar items by first using ticks() function to convert the DateTime timestamps to ticks, and then calculating the difference,
while StartA & B are the Start Times of the events, 
and EndA & B are the End Times of the events.

 

Screenshot 2022-10-28 010247.jpg


and then calculating the difference with

 

div(div(mul(sub(int(outputs('EndA')),int(outputs('StartB'))),100),1000000000),60) .

 

The result is available to me as a tick. As you can see below, until here it's working fine. 

 

Screenshot 2022-10-28 005853.jpg


My struggle is to update the final DateTime within "Update Event".
I've tried this: 

addMinutes(outputs('EndB'),outputs('Differenz'))


But it's not working. I got an Error.
How can I ADD the tick number value to an Outlook calendar event? Just by convert back to string?

 

Screenshot 2022-10-28 005931.jpg

 

Thanks for any advise and help!

Categories:
I have the same question (0)
  • Verified answer
    ultrAslan Profile Picture
    100 on at

    Ok, I guess the error is there because my first argument in
    addMinutes(outputs('EndB'),outputs('Differenz')) 

    is wrong.

    Not the output of "EndB" which is just a tick, instead I have to take
    the original  "items('Apply to all')['end']" value which is as string in DateTime Format.

  • v-liwei-msft Profile Picture
    on at

    Hi @ultrAslan 

     

    Glad to see you solved the problem. 

    You could mark your answer/solution as a 'Solution' to allow more people with the same problem to solve their own problem as quickly as possible. 

    Thank you so much! 

     

    Best Regards,

    Levi

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard