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!