I have a question. I have already created a few apps for our company. These apps contain a wide variety of formulas. Is it possible to pack a large formula into a variable and collect it centrally. I want to collect the formulas in one place and only call them up when I really need them. This is then clearer in the entire app. Is this possible? How do you do it so that you keep track of things?
Thank you in advance for your suggestions.
greetings from germany
This isn't exactly the same thing, but the workaround I would suggest is to build the formulas into a component in a component library. Setup inputs and one or more output properties. Then put all the logic into the component. If you add the component to an app you can then update the logic in the component library and push out changes as long as you don't change the input and output properties.
how do you mean that exactly?
In a component you can only create objects that are repeated over and over on every screen (for example a header or a picture).
greetings from germany
Normally, components are used to create controls, like a menu, that can be used in multiple apps. But to do that they have both input and output custom properties. So what I am suggesting is that you create a custom component in a component library that doesn't actually have any visible controls (or maybe just a label so you can keep track of it). Then create input properties for the values that need to be used to calculate the variable and an output property to report the value back out. Then inside the component set a variable formula that uses the input properties to calculate the value. report that value as the output property. Now that the logic is encapsulated you can add the component to the app, set the input values, and use the output value. If you need to change the formula you can edit the original component in the library and publish an update.
I'm standing on the hose right now. I have a save button in my app.
In my app I have a save button and a yes / false field. Currently is as follows:
If the Yes / No field is set to "false", Formula 1 expires. If it says "Yes", Formula 2 expires. These formulas are all stored behind the save button.
But my intention is the following:
If the field is on "false", then call the formula 1 from the central memory or from the variable. If the field is set to "yes", then call formula 2 from the central memory or from the variable.
So I have all formulas in one place and don't have to search through the whole app, where the same formula may be stored again.
Here's a simple example
Custom component properties
Component with a single label
Component added to app
Each textbox provides one of the input properties for the component and the Total label reports the Output of the component.
So I'm suggesting you set the Yes/No as an input property (and any other values you need for calculation). Then put the formulas in the component. If the input is Yes, use formula 1, if no then formula 2. Output of the formula is in output property.
Of course this all depends on what the formulas do. If they do complex patches or something then it probably won't work. If they generate some value or values then they will.
Yes, it could be done. But I'm not sure its feasible due to the number of input values required to do the work. I'm not sure there is currently a better way to do what you are doing. I think you may be well beyond what should be tried using a no-code approach. Manipulating this many moving parts at one time should really be done with a formal compiled program rather than Power Apps.
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Check out our new Discover Your Career Path blog post series and get all the details.