Power Platform Community Forum Thread Details

I would like to make an app-based solution for performing calculations and am not sure of the best way to make it. I’d like to make the app UI aimed at laptop/web-app usability for inexperienced engineers, but I am interested in learning how to use the same app for phones and laptops for future development. I also need an exportable Results files with inputs and calculations. I don't really have experience in coding for databases, but am usually able to use brute force logic through coding adjacent situations, so I think I can find my way forward with some direction.

I have everything worked out in Excel using drop-down data validation lists, index-match formulas for lookups, and number input cells for additional values. I also have a lot of IF formulas to handle multiple configuration options that would lead to changing formulas. In all, I think there are 100-200 cells with formulas that layer on top of one another as inputs and outputs for the algebraic formulas. There are also about 200 different material mechanical properties referenced in multiple tables, that will potentially grow over time (I add more data, Users just use the custom input property area). There are currently 5-20 inputs with 2-3 needed outputs and 20 alternate output calculations for mechanical calculation troubleshooting (evaluating multiple types of failures/limitations).

All of the calculator examples I have seen are just your basic “How to make a calculator” tutorials that let you input a couple values and press a button to multiply/divide/add/subtract them. I think I can see how making several layers of calculations can get me to the result I need, but it seems like I am basically starting from scratch. Are there any tutorials/tips out there for converting an existing Excel based calculator solution into a Power App?

For anyone interested in more context, I have multiple calculators for mechanical and hydraulic equations, but the most difficult example referenced above is a bolt torque/stress calculator that uses equations from ASME B1.1, SAE TP 770420 , and T9070-AJ-DPC-120/3010 Appendix G. The Excel sheet calculates torque, preload, bolt stress, compressive joint stress, joint separation, thread stripping, etc. I have also added in a couple equations from other sources, such as Von Mises stress calculations, adding shear and axial stress. The other less complex calculators for other situations use equations from ASME B31.1, ASME BPVC, and multiple engineering text books.

Categories:

Building Power Apps