CODEWITHSUNDEEP
datetimesharepointpowerappsexcel-dates
ahmug
ahmug

Reputation: 1

Wrong date time format when insert date from PowerApps into Sharepoint list

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

Date settings in PowerApps

Data in Date columns in Sharepoint List

Date columns setting in Sharepoint List

Data in excel column export from Sharepoint List

Upvotes: 0

Views: 1894

Answers (1)

JBerg
JBerg

Reputation: 446

In Power Automate you can use expressions to remove the decimals.

substring(string(outputs('Compose')),0,indexOf(string(outputs('Compose')),'.'))

Replace outputs('Compose') with your date values. So this will turn 1023.45 into just 1023

Upvotes: 0

Related Questions