This is because Excel stores dates as an integer. The integer represents the number of days that have elapsed since the 1st January, 1900. The following post should tell you everything you need to know to solve your problem: Easily convert Excel Dates to usable Power Automate Dates. Note the section on Validate the Excel data first .