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

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,963 Moderator on at

Like (1)

Report
Copy link

Link copied!

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 37,160 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

@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