Textbox not accepting blank value

(0) Share

Report

Posted on by _arc

Hi,

I have built two powerapps both of them use two seperate sharepoint lists as backend datasource.

I have used 'Edit Form' control to edit & display data. These are auto generated controls from Forms

Powerapp 1:

The score field below accepts blanks & does not throw conversion error

Here are some other properties of the text box control

Sharepoint list 1

Powerapp 2:

The score field below does not accept blanks & throw conversion error I am not sure what is the issue as

Sharepoint list 2

Both the sharepoint lists have identical schema - Scores have been set as Text
Both the apps have same identical code text boxes are set to accept numbers

Not sure if this is an issue with app configuration (Apps are identical 😞 ) or sharepoint list itself.

Sorry for the very little information that I have provided but there is nothing much in the app. It has a edit form which has Sharepoint list set as datasource. All the app does is shows / updates sharepoint list through forms.

The app must allow blank to be saved but I don't understand why one app allows while the other doesn't.

Could someone please help me in figuring out this issue.

Regards,

_arc

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Change your code with this:

IfError(Value(DataCardValue19_1.Text), Blank())

Was this reply helpful? Yes No
Verified answer

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @_arc ,

If it helps try below code.

If(!IsBlank(DataCardValue19_1.Text),Value(DataCardValue19_1.Text),"")

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
_arc 34 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @PriyankaGeethik thank you very much your solution worked :-). I was never able to find the root cause of the issue but nevertheless many thanks I was able to fix it.

Thank you @zmansuri your solution works too.

Was this reply helpful? Yes No