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

Help Studio
, ,
1

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

power app user details
power app user details496×797 30 KB

Contacts.xlsx (11.4 KB)

1 Like
2

@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.

3

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!

4

Creating contacts.zip (42.9 KB)

file attached

1 Like
5

simulate
simulate356×832 59.8 KB

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

1 Like
6

thanks
will give it a shot

1 Like
7

Hi @gary,

No, I mean this one:

image

8

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