Unanswered

input number date give error message with format problem

(1) Share

Report

Posted on by lucarios1705

Hello everyone,

i create a app from Sharepoint Liste (columns formatted in sharepoint with date and time) with different future dates (its Textinput fields)...but when i beginn type a number in the cell of powerapp i become a error message.

dont know how i can fix the error code with the format in powerapps formular in the right way.

How should i format the formular or the sharepointlist?

thanks in adavanced for help.

BR, Tom

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (1)

Report

Hi @lucarios1705

Sorry I cannot read that error, can you please translate it for me to English

That being said, you mention typing in a Number, but you are showing a Date Conversion. What exactly are you trying to get?

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Hello,
the error code say: cannot convert the inputed number to date or Time format.
i want to switch from date format mm/dd/yyyy to the german "de" Input dd/mm/yyyy but every time i insert a number higher as 12 (powerapp mean the mm first) but i want to insert first dd and save this to my sharepoint list. I did not know a correct formular to shown the date in powerapps for german format date.
I also switch the settings of app to utc vienna but nothing changes.
BR, Tom

Was this reply helpful? Yes No
Verified answer

timl 36,383 Super User 2025 Season 2 on at

Like (1)

Report
@lucarios1705

You can avoid this error by wrapping it within a call to IsError:

IfError( Text(DateTimeValue(ThisItem.'P2L 1');DateTimeFormat.ShortDate); "" )

Another thing you can consider is to use the Date picker control instead of a text input control. With the Date picker control, you can reference the SelectedDate property so there won't be any need to call DateTimeValue to convert the text value to a date object.

Was this reply helpful? Yes No