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!

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (2)

annajhaveri 8,531 Most Valuable Professional on at

Like (1)

Report

@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.

Was this reply helpful? Yes No
RK-23070616-0 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report

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.

Was this reply helpful? Yes No
RK-23070616-0 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Verified answer

annajhaveri 8,531 Most Valuable Professional on at

Like (2)

Report

@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

Was this reply helpful? Yes No
RK-23070616-0 on at

Like (1)

Report

thank you annajhaveri, this is really awesome! 🙂

Was this reply helpful? Yes No
oldandnew 29 on at

Like (0)

Report

This solution works great! Is there a way to show just the month and year as MMM yy?

Was this reply helpful? Yes No