Forum Discussion

JosephNierenberg's avatar
JosephNierenberg
Iron Contributor
Jan 13, 2022

Adding Days

I am unable to figure out how to do something that is probably not very difficult.... In a Flow that creates a list item, I would like the Start Date to be the date that the trigger fires, and the Due Date to be one day afterward. I cannot figure out how to create the Due Date calculation. I've tried the Add Days function, but I'm not certain how to do it, and my attempts result in errors.

How can I make this happen?

Thanks in advance.

  • RobElliott's avatar
    RobElliott
    Jan 18, 2022

    JosephNierenberg you said you wanted the date that the trigger fires. That is today which in Power Automate is the expression utcNow().  So you add that into the expression as I showed in my previous post, you don't/can't select it.

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User

    • JosephNierenberg's avatar
      JosephNierenberg
      Iron Contributor

      RobElliott  That looks simple enough, but it doesn't seem to work.

       

      1. The only dynamic choices available for the "Due Date" field are Modified and Created. This is fine for my purposes. "Created" is defined in the dynamic expressions options as "When this item was created."

       

      2. If I add 'Created' first and then try to add days it doesn't work. Adding the addDays function and then clicking the 'Created' expression as the timestamp in the addDays function results in this:

      addDays(triggerOutputs()?['body/Created'])

       which makes no sense to me.

       

      3. If I just add the expression addDays() then 'Created' is not an available option to insert as the timestamp. If I add it anyway, to produce

      addDays (Created,1)

       then the system returns an error that the expression is invalid.

      • RobElliott's avatar
        RobElliott
        Silver Contributor

        JosephNierenberg you said you wanted the date that the trigger fires. That is today which in Power Automate is the expression utcNow().  So you add that into the expression as I showed in my previous post, you don't/can't select it.

         

        Rob
        Los Gallardos
        Microsoft Power Automate Community Super User

Resources