I cant seem to find a way around this issue. I am using Power Automate to get information from a table in excel and one column happens to be a column "Onset Date" .
This happens to be a custom format in Excel. When I run my flow the value becomes the excel serial date format "Onset Date": "45555.1666666667". How do i write the correct expression in my compose action within an apply to each to get it to display like this "9/20/2024 4:00 AM"?