How to insert date from excel into a web browser app without hh:mm

I am basically reading an excel file from an outlook message then opening a browser (Microsoft Power apps) to type multiple fields viz.

  1. Name
  2. DOB
  3. Phone number
  4. Email
  5. Company Name
  6. Role
  7. Address
    All the fields get stored but the date gets stored in mm/dd/yyyy 12:00 AM
    The excel file only has the format mm/dd/yyyy
    If I input the data manually into the power app the date is stored as mm/dd/yyyy so no issues there, however using the bot creates the time input
    Any suggestions to read each and every row and input date without the time
    Thank You

Contacts.xlsx (11.4 KB)

1 Like


To Convert the date from one format to the expected format will be like


Convert your Date variable as above, It will only insert Date without Time.

Hi @gary1,

Have you tried setting SimulateType property to true?

If this solves your problem, kindly mark this post as solution to close this topic.


Creating (42.9 KB)

file attached

1 Like

tried simulate if the attached is what you are referring to
it did not work

1 Like

will give it a shot

1 Like

Hi @gary,

No, I mean this one:


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.