Power Platform Community Forum Thread Details

I am trying to create a PowerAutomate flow that periodically goes through an Excel sheet with a large list of dates for various steps of a project and creates corresponding events on an Outlook calendar. Initially, I followed this tutorial: Add Outlook Calendar Events in Excel Using Power Automate, but I'm having a lot of issues trying to get the date fields to work.

This is the Excel sheet I'm working from, and it has Start/End Date columns that are set to a date format. Inputting those dynamic fields into the Start/End Time parameters for the "Create Event" action kept returning errors, so I tried creating another set of columns that formatted the dates as numbers so I could try using the addDays function. However, I am now receiving errors saying that those Start/EndDateNum columns are apparently containing strings, so it can't use that function.

I tried looking into a lot of different options and formulas to get the date to work correctly, but I'm not having any luck. Below is the current formula in the Start/End time parameters that returned the above error.