cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Esthela
Regular Visitor

Power Apps / DB in Excel date format as text

I developed an APP in Power APPS using Excel as database, I know my mistake. I'm migrating now to a Sharepoint list BUT... some dates were stored as text and I don't know how to fixed to load the correct data in SP. Please help!!!!

 

fechas.PNG

2 REPLIES 2

@Esthela 

If you use Excel data source it stores it like this

Check if below formula converts that bizarre looking number to a Text version of the Date Time

//psuedocode - change YourDateField_Value to what's appropriate for you - this is where your number like 44840.09375 goes, for example

Text(
     DateAdd(
          DateTimeValue("1899-12-30 12:00:00 AM")
         ,RoundDown(
               (Value(YourDateField_Value) * 86400)
              ,0
          )
         ,TimeUnit.Seconds
     )
    ,ShortDateTime
)

 Does it work @Esthela ?

 

Also check the below thread in case it helps for more context and information:

Date shown as number string instead of date 

Esthela
Regular Visitor

Thanks @poweractivate 

I'm sorry, possibly I am too inexperienced to understand what you are suggesting. I wrote your code on the [Text Property] of the [Title] of the [gallery] and the results were weird. I have a mixed data; some were store right some were stored as bizarre numbers.

Let me try to explain myself again: I want to export the data that I already collected in Excel to a share point list that is working as the database linked to the app instead of the spreadsheet.

I don't know how to recover the wrong dates in Excel to fill the SP list.

😞

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,948)