Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Date problem

Posted on 21 Nov 2024 12:12:47 by 42
 Why does the date format change when I dump the data from one Excel to another with Power Apps?
 
I collect the data from an Excel with a gallery, the data I collect is in date format, and when it comes to dumping it into another Excel, the format automatically changes. I need the format to be "dd/mm/yyyy" but sometimes it changes the month for the day can someone help me please
Categories:
  • timl Profile Picture
    timl 31,946 on 24 Nov 2024 at 16:12:36
    Date problem
    How are you updating the records? Are you using a Form or calling Patch? If it's the latter, can you post the formula that you're using?
  • WarrenBelz Profile Picture
    WarrenBelz 143,246 on 24 Nov 2024 at 07:14:54
    Date problem
    Responding as no one else has - Excel and Dates when used with Power Apps are problematic at the best of times - are you able to use SharePoint here ?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,246

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,884

Leaderboard