Answered

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

All responses (3)

Answers (1)

Verified answer

timl 34,933 Super User 2025 Season 1 on at

Like (1)

Report
Re: input number date give error message with format problem

@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.
Community Power Pla... on at

Like (1)

Report

Re: input number date give error message with format problem

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
Michael E. Gernaey 40,296 Super User 2025 Season 1 on at

Like (1)

Report

Re: input number date give error message with format problem

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