Answered

Value Conversion Error

(0) Share

Report

Posted on by Phineas

5,331 Moderator

I have Gallery1, in which I am collecting data to patch to an SP List.

I am getting the following error when I choose an item from the 'Activity' dropdown.

The error message doesn't provide any more information clarifying which field is kicking back the error.

How do I determine which field is causing the error?

I'm assuming the error is in the 'Total' field, which has the following formula. What am I missing?

If(IsBlank(Activity_ComboBox.Selected.Value), "0", "$" & Activity_Quantity_Fld.Text * Activity_Rate_Fld.Text)

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

Verified answer

WarrenBelz 155,640 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Phineas ,

You need to convert the calculation to Text

If( IsBlank(Activity_ComboBox.Selected.Value), "0", "$" & Text(Value(Activity_Quantity_Fld.Text) * Value(Activity_Rate_Fld.Text), "#,###.00") )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

Actually, same error.

Was this reply helpful? Yes No
WarrenBelz 155,640 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Phineas ,

You do not have anything in the Activity Quantity field. You also really need to test all the values

If( Len(Activity_ComboBox.Selected.Value) = 0 || !IsNumeric(Activity_Quantity_Fld.Text), "0", "$" & Text(Value(Activity_Quantity_Fld.Text) * Value(Activity_Rate_Fld.Text), "#,###.00") )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

The error occurs before I have a chance to add any content to the 'Activity Quantity'.

The error is occuring on change of the Combo Box, and happened again with the
new formula.

Was this reply helpful? Yes No
WarrenBelz 155,640 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Phineas ,

Try adding the numeric test to the Rate field as well

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

I had this in the Default of 'Activity Qty' - If(!IsBlank(Customer_Number_Fld.Text)," ").

I updated the formula to If(!IsBlank(Customer_Number_Fld.Text),"0"), which seems to have corrected the issue.

As an aside, have you seen my post about my 'Cache Collection' issue?

If not, can you take a look and provide any suggestions?

Was this reply helpful? Yes No
WarrenBelz 155,640 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Phineas ,

That is not a solution to the question you asked (marking it will only confuse people reading this as that field is nowhere in your formula). The real issue was that the error was not in the formula you posted, so it is impossible for anyone to help you with the available information provided.

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

Okay. Can't undo it now.

Hopefully, people will put two and two together and see, in my case, not having valid content in the 'Activity Qty' field was part of the problem.

Was this reply helpful? Yes No
WarrenBelz 155,640 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Phineas ,

They may come up with 5 . . .

Was this reply helpful? Yes No