web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Date from Form to Excel.
Power Apps
Unanswered

Date from Form to Excel.

(0) ShareShare
ReportReport
Posted on by 53

Hi.

I need to retrieve the start and final hours from a service operation in my app using the first and second date-time pickers.

 

 

This form sends the data to Excel and it cannot be in text format, if possible, because I need to calculate the time gap between both times.

I need the format to be "DD/MM/YYYY HH:mm", but every solution I've tried for similar cases just gives me the same results (image2).

 

inicio = start

fim = end

excelappont.png
appapont.png
Categories:
  • v-bofeng-msft Profile Picture
    Microsoft Employee on at

    Hi @thgdamasceno ,

     

    How did you submit the record? Could show me the formula? If it is a form , could you please show me the inicio datacard's update property?

     

    In addition ,if you want to format a datetime value in Excel , you need to set the column's format in Excel.

    vbofengmsft_0-1690335573844.png

     

    Best Regards,

    Bof

  • thgdamasceno Profile Picture
    53 on at

     

  • thgdamasceno Profile Picture
    53 on at

    Yes im using a form to submit. 

    BTW if i just change the column format in excel as you said, it just returns a infinite sequence of #####

    print updatein.png

    print updatein.png

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 432 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 347

#3
WarrenBelz Profile Picture

WarrenBelz 254 Most Valuable Professional

Last 30 days Overall leaderboard