Hello @Abhishek Vyas
Thanks for the ask and also using the Microsoft Q&A.
I was able to get this solution working using mapping dataflow(MDF).
We need to use the derived column , todate and coalesce function.
coalesce(toDate(Somedate,'MM/dd/yyyy'),toDate(Somedate,'yyyy/MM/dd'),toDate(Somedate,'dd/MM/yyyy'),toDate(Somedate,'MMddyyyy'),toDate(Somedate,'yyyyddMM'),toDate(Somedate,'MMddyyyy'),toDate(Somedate,'yyyyMMdd'))
Please find the attached below to get the implementation . Please do let me know how it goes .
Thanks Himanshu
Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members