For those with similiar issues. I have finally found the solution.
I found out that excel online from onedrive and Powerapps aren't that good friends when it coming to formatting.
So i had to change the default format in excel to their date format through formatting.
The code i needed to use for the gallery:
View solution in original post
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand