cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Submit form

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.

8 REPLIES 8
Highlighted
Skilled Sharer
Skilled Sharer

Re: Submit form

@José_Danilo 

 

You can use ms-flow and runs in on all items/records.

Highlighted
Regular Visitor

Re: Submit form

@panand99  Is there a tutorial on how to do it?

Highlighted
Skilled Sharer
Skilled Sharer

Re: Submit form

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.

Highlighted
Regular Visitor

Re: Submit form

@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.

Highlighted
Super User III
Super User III

Re: Submit form

Hi @José_Danilo 

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.

Highlighted
Regular Visitor

Re: Submit form

@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.

Highlighted
Microsoft
Microsoft

Re: Submit form

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.

Highlighted
Regular Visitor

Re: Submit form

@timlThanks for the answer, after doing the calculations how do I update a collection for all items and then send it to excel?

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,580)