Unanswered

Add Days for Date Field and Populate Results in Another Field

(0) Share

Report

Posted on by muggs4477

I have been trying to create a flow that will add days to an existing date field titled "Effective Date" and populate the results into another field titled "Next Review Date". I'm using the formula below in the Compose function.

formatDateTime(addDays(EffectiveDate(),365),'yyyy-MMMM-dd')

When I first created the SharePoint list, I created the "EffectiveDate" column with no spaces and then went back added a space to "Effective Date". I have check the source code and it states that the field name is "EffectiveDate" and that the display name is "Effective Date" in case any of this makes a difference.

When I test the flow, I receive a message to allow access to my location which I select "Allow". Is this necessary? If yes, I will select "Remember this decision".

Then the flow fails with the below error. I'm not including any of the functions past this because they haven't been tested since I can get pass the Compose function.

Any help is greatly appreciate with what is wrong with the formula to obtain the Effective Date + 365 days output value.

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@muggs4477 You will need to use the internal column name of your Effective Date column. Keep in mind that the internal column name may not always match the name displayed in your Sharepoint list. If you aren't sure how to get the Internal Column name, you can refer to this section of one of my YT Tutorials.

You may also be interested in this YT Tutorial:

How to Work with 📆 Dates in Power Automate | Example Scenarios and Tips & Tricks

Are you easily stumped when working with Dates in Power Automate? In this Power Automate tutorial, I’ll show you how to compose an expression that will return a future date, a past date, how to count the number of days between two dates, how to check for a birthdate and anniversary date as well as tips and tricks when working with dates in Power Automate.

I’ll cover some common use cases and concepts that can help you to build better Power Automate flows. Feel free to skip ahead using the timestamps listed below. I’ve also linked a few other tutorials that you might be interested in as well.

IN THIS VIDEO:

✅ 4 Date Functions You Need to Know

✅ How to use the Convert Time Zone Action

✅ How to Get a Future Date

✅ How to Get a Past Date

✅ How to Return SharePoint Items Due in a Number of Days

✅ How to Return SharePoint Items Due within a Date Range

✅ How to write a Filter Query for SharePoint Items Due in 30, 60 and 90 Days

✅ How to Calculate the Number of Days between Two Dates

✅ How to Check for a Birthdate and Anniversary Date

✅ How to work with Dates and Times in Excel

✅ How to use a Manual Trigger with Date Input

✅ How to Output Dynamic Text with an Expression

✅ How to Check if a Date Falls on a Weekend

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No
muggs4477 84 on at

Like (0)

Report

The internal column name for my column is EffectiveDate which I used in the addDays formula so I don't know where to go from here. Still need help please.

Was this reply helpful? Yes No
z_prins 12 on at

Like (0)

Report

I am pulling from a Share Point list to send an email based on a task due date. I am looking for what the expression(s) is/are that I would need if I am trying to send an email reminder 1 day before a due date?

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report
@muggs4477 Your expression looks incorrect as you need to insert dynamic content in your expression to get the date from your column. The red text is incorrect.

formatDateTime(addDays(EffectiveDate(),365),'yyyy-MMMM-dd')

Without seeing your full flow I have no idea where the Compose action is in relation to your entire flow. If you are unable to see the Effective Date dynamic content from the list of dynamic content you'll need an expression. Check out this section of my recent YT Tutorial: 7 Functions You Need to Know | ⚡️Expression Essentials: Part 1⚡️

In this section, I'll cover how to get dynamic content with an expression when the dynamic content you need isn't listed in the dynamic content menu.

In the full tutorial I cover 7 functions you need to know when getting started with expressions.

1️⃣ empty()

2️⃣ coalesce()

3️⃣ equals()

4️⃣ if()

5️⃣ concat()

6️⃣ length()

7️⃣ split()

I cover how to use these functions in expressions and I’ll also cover common mistakes when it comes to writing expressions and show you a few tips and tricks along the way.

As a beginner or even an intermediate flow builder—expressions can seem a bit complex at first, I’m going to try to simplify it for you. If you want to level up your flows by writing expressions—keep watching!

IN THIS VIDEO:

✅ What is an Expression?

✅ What is a Function?

✅ What Does Wrapping a Function Mean?

✅ How Do I Insert an Expression?

✅ How to Use a Compose action

✅ How to Navigate the Expression Builder with Arrow Keys

✅ How to use the Expression Tooltip

✅ Common Mistakes When Writing Expressions

✅ How to differentiate a null from an empty string

✅ How to Get Dynamic Content When it’s Not Listed

✅ How to Use a Get Item Action to Verify Dynamic Content Output

✅ How to Convert Strings to Lower Case

✅ How to Troubleshoot the if() Function

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@z_prins You might find these YT tutorials helpful:

Send Emails Based on a 📆 Date Column in SharePoint with Microsoft Power Automate

In this Microsoft Power Automate tutorial, I’ll show you how to build a flow that will send a Happy Birthday email to a user based on a date column in a SharePoint list. The SharePoint list also contains a column with a Manager’s name which we’ll use to send a three-day and day of reminder to the user’s manager.

This automation will use the Filter Array action to filter out all SharePoint list items where the user’s birthday is today or in three days. This flow can apply to a variety of scenarios such as:

📅 Student Birthdays

📅 Project Due Dates

📅 Contract/Membership Renewals

📅 License Expirations

📅 Client Anniversaries

IN THIS VIDEO:

✅ How to Send an Email based on a Date Column in SharePoint

✅ Using the Recurrence Trigger in Power Automate

✅How to Use the Filter Array Action with multiple conditions

✅ How to Get Dynamic Content from a Filter Array Action

✅How to Get a Date Three Days from Today

✅ How to Create a Dynamic Date Based on utcNow()

✅ How to Return a Count of Items

✅ How to initialize and set a variable

✅ How to use the Send an Email (V2) action

✅ How to send test emails

------

How to Work with 📆 Dates in Power Automate | Example Scenarios and Tips & Tricks

Are you easily stumped when working with Dates in Power Automate? In this Power Automate tutorial, I’ll show you how to compose an expression that will return a future date, a past date, how to count the number of days between two dates, how to check for a birthdate and anniversary date as well as tips and tricks when working with dates in Power Automate.

I’ll cover some common use cases and concepts that can help you to build better Power Automate flows. Feel free to skip ahead using the timestamps listed below. I’ve also linked a few other tutorials that you might be interested in as well.

IN THIS VIDEO:

✅ 4 Date Functions You Need to Know

✅ How to use the Convert Time Zone Action

✅ How to Get a Future Date

✅ How to Get a Past Date

✅ How to Return SharePoint Items Due in a Number of Days

✅ How to Return SharePoint Items Due within a Date Range

✅ How to write a Filter Query for SharePoint Items Due in 30, 60 and 90 Days

✅ How to Calculate the Number of Days between Two Dates

✅ How to Check for a Birthdate and Anniversary Date

✅ How to work with Dates and Times in Excel

✅ How to use a Manual Trigger with Date Input

✅ How to Output Dynamic Text with an Expression

✅ How to Check if a Date Falls on a Weekend

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No
z_prins 12 on at

Like (0)

Report

Here is the flow I currently have, the email is to send 1 day in advanced based on the task due date. There are multiple tasks each week with different due dates.

Was this reply helpful? Yes No
Verified answer

muggs4477 84 on at

Like (0)

Report
I ended up switching it up a bit. I'm taking the "Effective Date" column and adding the days that are in the "Review Frequency" column. The flow will run when either the "Effective Date" or the "Review Frequency" fields are changed. It's working perfectly.

addDays(triggerOutputs()?['body/EffectiveDate'], int(triggerOutputs()?['body/ReviewFrequency/Value']))

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@z_prins I would recommend starting a new thread as this one has been marked solved.

As mentioned in a previous post, check out the tutorials linked below—concepts covered in these tutorials should help you in your flow. It's always best practice to filter out your items first BEFORE looping through them. Running an apply to each action and condition check on each item in your list is inefficient.

Send Emails Based on a 📆 Date Column in SharePoint with Microsoft Power Automate

How to Work with 📆 Dates in Power Automate | Example Scenarios and Tips & Tricks

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No