I have searched the forum a lot and tried a lot of things without success (compose, formatDateTime, StartDate...).
I need to import from an excel (Business) date (Eckendtermin) to a SP list. I only have the typical 43203, 43206... numbers. I don't want to compare it to other dates. Just import it. I show you some pictures of my flow.
When getting date from Excel Business, I am having the same issue. The date from Excel will return as 43349, etc. I haven’t found a way to convert the number to a date then save it into SharePoint list.
Then I tried with the Excel, the dates are returned properly and they are able to be saved to Excel without issues.
Please try to use Excel instead of Excel Online, I assume that it will work as expected.
Community Support Team _ Mabel Mao If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.