Convert a string equation to its relative value!

(1) Share

Report

Posted on by HS-07100930-0

I am trying to output a cost, which is calculated by an equation. however the label just outputs the equation as a string. Within excel I would typically use a macros Eval() function, however this does not exist in power apps. My outputted equation is based off of another dropdown (Unique Ref no.) therefore I cannot simply write the equation out. I have attached a photo of my app below.

Categories:

Building Power Apps

Screenshot 2024-1...

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Michael E. Gernaey 53,493 Super User 2025 Season 2 on at

Like (1)

Report

Hi, please share the inputs to this.

After I see the input (where this formula is written) it will make more sense.

Not sure what you mean by you cannot write it out because its based on another drop down.

Was this reply helpful? Yes No
timl 36,415 Super User 2025 Season 2 on at

Like (0)

Report

Hi HS-07100930-0

With Power Apps, there's no Eval function. Therefore, there's no built in way to parse the result of an equation/expression.

There's no simple way to implement Eval in Power FX. Therefore, the approach I'd take is to try to evaluate the equation outside of Power Apps.

I've not tried this but it may be possible to write a .NET Azure Function app and to connect it to your Power App via a custom connector.

Was this reply helpful? Yes No
HS-07100930-0 10 on at

Like (0)

Report

@FLMike this is the code that is in the label. I have a dropdown called 'Unique Ref Nr', Seen below:

Was this reply helpful? Yes No