I am basically reading an excel file from an outlook message then opening a browser (Microsoft Power apps) to type multiple fields viz.
- Phone number
- Company Name
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
Contacts.xlsx (11.4 KB)