Answered

PowerApps encountered an internal error trying to evaluate this expression

(0) Share

Report

Posted on by siimgorczyca

Hi,

I made a quick mockup of an application to test some functionalities and they were working fine there. Then I wanted to move the functionalities to an actual working application and then it results in an error. I have a few text input controls and an HTML text control which should show a summary of the provided values in the text inputs. The HTML text formula is:

"<b>Max. number of companions: " & varAdditionalAttendeesLimit & "<br>Total number of companions: " & txtAdditionalAttendees1_1.Text+txtAdditionalAttendees2_1.Text+txtAdditionalAttendees3_1.Text+txtAdditionalAttendees4_1.Text & "<br>Total fee for companions: " & (txtAdditionalAttendees1_1.Text * varAdditionalAttendeesFee1) + (txtAdditionalAttendees2_1.Text * varAdditionalAttendeesFee2) + (txtAdditionalAttendees3_1.Text * varAdditionalAttendeesFee3) + (txtAdditionalAttendees4_1.Text * varAdditionalAttendeesFee4)

When all of the text inputs are filled, everything is ok. But when at least one of them is blank, the HTML text disappears and when I hover over the text input name in the formula, it says e.g.:

txtAdditionalAttendees1_1.Text = PowerApps encountered an internal error trying to evaluate this expression | Data Type: Error

Everything's working fine in the other application (mockup one), I tried replacing the HTML text with labels and the same error occurs. Creating a different screen also did not help. Is that some temporary Power Apps bug?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

timl 36,780 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @siimgorczyca

Most likely, the empty text input values are causing this problem.

You could try converting these empty values to an empty string with the help of the coalesce function.

https://docs.microsoft.com/en-gb/powerapps/maker/canvas-apps/functions/function-isblank-isempty

You would replace the references to your text input controls with code that looks like this:

Coalesce(txtAdditionalAttendees1_1.Text, "" )

Maybe that might solve the problem.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,889 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @siimgorczyca ,

You will have to test each item for no input.As an example

"Max. number of companions: " & varAdditionalAttendeesLimit & " Total number of companions: " & If( IsBlank(txtAdditionalAttendees1_1.Text), 0, Value(txtAdditionalAttendees1_1) ) + If( IsBlank(txtAdditionalAttendees2_1.Text), 0, Value(txtAdditionalAttendees2_1) ) + If( IsBlank(txtAdditionalAttendees3_1.Text), 0, Value(txtAdditionalAttendees3_1) ) + If( IsBlank(txtAdditionalAttendees4_1.Text), 0, Value(txtAdditionalAttendees4_1) ) & " Total "

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
siimgorczyca 27 on at

Like (1)

Report
Copy link

Link copied!

Thanks, I actually managed to fix it by replacing the empty value with a 0, but I'm wondering why it's working in one Power App and resulting in an error in the other.

Was this reply helpful? Yes No
timl 36,780 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @siimgorczyca

I'm not sure why it's working in one Power App and not in the other. Are your apps both in the same environment and are they based on the same version?

Just to clarify my earlier comment, what I should have said was to replace the blank values with a 0 and not a empty string - that was my mistake.

"Max. number of companions: " & varAdditionalAttendeesLimit & " Total number of companions: " & Coalesce(txtAdditionalAttendees1_1.Text),0) + Coalesce(txtAdditionalAttendees2_1.Text),0) + Coalesce(txtAdditionalAttendees3_1.Text),0) + Coalesce(txtAdditionalAttendees4_1.Text),0) + & " Total "

Was this reply helpful? Yes No
siimgorczyca 27 on at

Like (0)

Report
Copy link

Link copied!

Yep, same environment, same user that created the app.

Was this reply helpful? Yes No