web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / addDays function - add...
Power Automate
Unanswered

addDays function - adding an event 6 months in advance

(1) ShareShare
ReportReport
Posted on by 20
I have a list that people add the days they did a check. Once someone has added this to the list, I want a flow to create a calendar event 6 months from the list date. (For example, someone added to the Sharepoint list and said they completed a check on 20/4/2024) - I want the flow to add a calendar event on 20/10/2024). 
Someone told me about the addDays function where I can add as many days as I like on, however I am stuck figuring out the string. 
 
This is what my list looks like: 
 
 
In my flow, I have a 'Create a group event (V2)' action. In the 'Start Time' is where I am trying to do the addDays function. 
In Dynamic content, it allows me to addDays and then select the specific title from the list (eg, Date Checked (mm/dd/yyyy) - you can see in the image below how the relevant title is highlighted blue to select it for the string. 
 
Once I have selected this, I can then continue with the string which shows as: 
addDays(triggerBody()?['DateChecked_x0028_mm_x002f_yy_x0'](),190,'MM/dd/yyyy')
 
However, when I go to click add, it comes up with this: 
 
When I try to do this in the Function, I can't see an option to select the 'Date Checked (mm/dd/yyyy)' option, and I do not know how to create a string for this? 
 
Please advise!
Categories:
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,335 Super User 2025 Season 2 on at
    Hi
     
    Why do you have the () at the end of the Date Field?
     
    addDays(triggerBody()?['DateChecked_x0028_mm_x002f_yy_x0'](),190,'MM/dd/yyyy')
     
    Take them out just have
     
    addDays(triggerBody()?['DateChecked_x0028_mm_x002f_yy_x0'],190,'MM/dd/yyyy')
     
    If that DateChecked is NOT a Date Field, and its Text, then you have to Convert it to a Date First
     
    Example
    addDays(parseDateTime(triggerOutputs()?['body/Created']), 190, 'MM/dd/yyy')
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard