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

[gary1 (Gary)]

Hi
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)

[Karuna (Karuna Devanagavi)]

@gary1

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

DateTime.Parse(DateVariable).ToString(“MM/dd/yyyy”)

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

[gustavo.cervelin (Gustavo Cervelin Custódio)]

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.

Thanks!

[gary1 (Gary)]

Creating contacts.zip (42.9 KB)

file attached

[gary1 (Gary)]

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

[gary1 (Gary)]

thanks
will give it a shot

[gustavo.cervelin (Gustavo Cervelin Custódio)]

Hi @gary,

No, I mean this one: