Power automate and date columns

Question

I have a power automate from SharePoint Excel to SharePoint List that contains 3 date columns, but each column needs the dates in.

I have tried changing string format
and compose with the 30/12/1899 add days but these dont seem to work

I have Office 365 business not premium package. How do I get each column with date to transfer over in date format?

many thanks in advance

Answer 1

Power automate is not currently supported here on QnA. The product group actively monitors questions in dedicated forums here.
https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

--please don't forget to Accept as answer if the reply is helpful--