Unanswered

Value does NOT work cannot be converted to a value

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Has anyone seen this error before, or know how to cure it. The error does not feature as a formula error - moreover it features as a Runtime error but doesn't stop the run execution.

The datacard corresponds to a SharePoint column that has been formatted as single line text, but is also displaying a number. The number is formatted in Power Apps to report a percentage or a some free text. I have tested it by typing the words " Does NOT work". The text patches through to SharePoint, but throws the error as reported. I was also hoping to display numbers as % if anyone knows how to do that in SharePoint (for a text column)

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

EddieE 4,641 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

Can you show the full error message?

Also, the DataCard setup would be helpful as well, eg Default property, any other properties that may affect this and the Update property of the DataCard

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous - what is the actual field type of the SharePoint column? It is not clear from your description whether it is single line text or number.

If it is a number, that error should be expected because it looks as if you're trying to Patch Text values into a Number column.

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous - just noticed @EddieE also responded, I'll leave you with him.

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

Like
a
(0)

Report
Copy link

Link copied!
Hi @EddieE,
Thanks for dropping by and taking a look. Darn thing is giving me some grief 😕
My goal is to give the user the option to enter data either as text or a number formatted as a percentage. Originally I had the SharePoint list column uploaded as number formatted to %, but this didn't give the option to add free text I added an additional column to the list as single line text and gave the corresponding app control the following code in the default property.
If( IsBlank(Parent.Default), "", Text( Value(Parent.Default) * 100, "#%" ) )
That permits to patch a percentage value back to the SP List. If I then attempt to patch any free text back to the list, I get an initial error message saying there is a conflict with the server to patch that specific comment back. However, if I refresh the app, it permits me to patch it back, but not without a Runtime error.

Was this reply helpful? Yes No
EddieE 4,641 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous

I think the issue is that you are trying to convert Text to a Value in your formula, eg

Value( "Does NOT Work") creates the error

To fix, you just need another condition inside your If() to cover this situation, try this

If( // condition 1 IsBlank(Parent.Default), Blank(), // condition 2 IsError( Value(Parent.Default) ), Parent.Default, // else condition Text( Value(Parent.Default) * 100, "#%" ) )

Also, to Patch the Blank(), make sure you have formula-level error management on in the Settings, ie

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @EddieE ,

You didn't specify whether your code is applicable for data formatted as numbers or single line text.

As Single line text, it only works for numeric values, while losing the "%" sign in the control.
It will not permit free text.

Was this reply helpful? Yes No