AddToTime: Using Dynamic Content within Expression

(0) Share

Report

Posted on by RK-23070616-0

Hi all,

I try to use AddToTime to add 1 month to a date on a certain trigger.

I want to do:

* get "Nächster Termin" (next date) - for example 2020/02/01

* add 1 Month to this date - results in for example 2020/03/01

My AddToTime looks like this and does not work:

addToTime('Nächster Termin',1,'Month')

I can get "Nächster Termin" from Dynamic Content.
But how do I integrate it into my expression?

Thank you in advance!

All responses (7)

Answers (2)

oldandnew 23 on at

Like (0)

Report

Re: AddToTime: Using Dynamic Content within Expression

This solution works great! Is there a way to show just the month and year as MMM yy?
RK-23070616-0 on at

Like (1)

Report

Re: AddToTime: Using Dynamic Content within Expression

thank you annajhaveri, this is really awesome! 🙂
Verified answer

annajhaveri 8,531 Most Valuable Professional on at

Like (2)

Report

Re: AddToTime: Using Dynamic Content within Expression

@der_cosmicyes , when you dont see the value in Dynamic Content when switching to Dynamin Content from expressions, you can use another trick of copy paste, as shown in video from below link

https://1drv.ms/v/s!An0udZ9uZBGJsx-lchz9f7Ey5GID?e=W7OJCu
RK-23070616-0 on at

Like (0)

Report

Re: AddToTime: Using Dynamic Content within Expression

Hi DamoBird365

Thank you, that´s what I wanted to hear 🙂
Unfortunately it still does not work.
If I flip back to Dynamic content I do not see "Nächster Termin" in there anymore.

As long as I do not set any Expression at all I see "Nächster Termin".
I think PowerAutomate might be a bit buggy here and there?!?

Nevertheless I solved it by changing my requirements a little bit. Fortunately I am in the position to do this 😉

I will try your trick again next time I need it!
Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report

Re: AddToTime: Using Dynamic Content within Expression

Hi @der_cosmicyes ,

There is a trick to this, if "Nächster Termin" is a field captured and retrieved by get items, when you build your expression, you can flick back and forth between expression builder and dynamic content, it's just that you often cannot see the dynamic content tab beneath.

So, start building your expression and then when you want to select your "Nächster Termin" field, switch back to dynamic content and then back to expression builder. It takes a bit of practice.
RK-23070616-0 on at

Like (0)

Report

Re: AddToTime: Using Dynamic Content within Expression

Dear annajhavei,

thank you for your reply.
I was hoping that this could be solved more easily as I do have all the information I need.
Let me ask more general:
Is there a way to put a Dynamic content into an Expression?
AddToTime wants a string as first parameter. I could add "2021/02/10".
But I do have da date as Dynamic Content - can I add this to the Expression? And if yes: how?
annajhaveri 8,531 Most Valuable Professional on at

Like (1)

Report

Re: AddToTime: Using Dynamic Content within Expression

@der_cosmicyes you can check this post https://sharepains.com/2018/06/25/microsoft-flow-calculate-next-month-resolved-with-workaround/ for reference on how to add month to a date.