News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Adddays function dynam...

Power Automate - Building Flows

Answered

Adddays function dynamic days value

Like (1) Share

Report

Report

Posted on 7 Aug 2023 06:37:58 by NicolleAbrahams

75

Hello,

I am having trouble adding a dynamic day value to the adddays funtion I keep getting the "Expression is invalid" error.

I would like to subtract days from today depending on an input from PowerApps.

This is my function for initialize a variable value,

addDays(utcNow(),-outputs('DaystoAdd'),'MM-dd-yyyy')

Any ideas on what I am doing wrong.

TIA

Categories:

Business Process Flows

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

ManishSolanki 15,085 Super User 2025 Season 1 on 07 Aug 2023 at 06:51:36

Like (4)

Report
Re: Adddays function dynamic days value

Hi @NicolleAbrahams

You need to multiple the DaystoAdd output with -1 to get the negative number which when added with addDays function gives you the past date.

Pls use the below expression:
addDays(utcNow(),mul(int(outputs('DaystoAdd')),-1),'MM-dd-yyyy')

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Helpful resources

News and Announcements

🌸You're Invited: Community Spring Festival Awards Celebration 🌸

Replay: Power Platform Community AMA - Copilot Studio | April

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 146,743 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 66,089 Most Valuable Professional

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans