I have a Powerapps app to allow user to select a date with dd-mm-yyyy format and direct insert it into Sharepoint list with same format (no time). It works normal but some records from users could insert date with time in Sharepoint List. It shows only date in Sharepoint list but when I export list rows to Excel, some records are with time. It made some steps of Power automate fails when reading data from excel because it accept integer only if it contains time it will have decimal number and caused errors. Would you please advise what's wrong? Thanks a lot.
Joanne
Data in Date columns in Sharepoint List