Hello, I have a form that performs calculations daily, how do I make the calculations after the information is saved in the table? I would not like to go into each item and submit the table, I would like it to be all items automatically.
Do you want it to calculated on schedule, if yes then you can creat a recurrence flow and update the items. There is a blog -https://powerusers.microsoft.com/t5/PowerApps-Community-Blog/How-to-dynamically-create-records-from-...
you can refer that. Here it is creating multiple records dynamically based on one list to another.
@panand99 I would not like to perform calculations in Flow, since they are already being performed on the forms, is it possible to just save all items? I am performing calculations in several fields.
Could you describe the types of calculations that you're carrying out on your form and the data source that you're using? If the calculations are not too complex, perhaps you could use a calculated column in SharePoint or SQL.
@timl Basically the calculations are of subtraction of dates, values and lease for months in some cases, my data source is excel. I tried to stay with the calculations in excel, but the Powerapps can not see the information, when they are with formulas.
Did you try to use collections before submitting your form?
You can save your calculations OnSelect event in your button to submit your form or even when your screen is visible perform your calculations, save them into a collection and allow user to make furter data input in you form and submit at the end.
You can check Collect and ClearCollect functions. If your form is not so big you can even create the UI with controls and just patch them without even using a form. That will allow you even more flexibility to make calculations, modifications or manipulations on your data.
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Fill out a quick form to claim your user group badge now!
Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities
Features releasing from October 2019 through March 2020
Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications