Power Platform Community Forum Thread Details

I've searched across various forums and videos and can't seem to figure out how to edit the button functionality to update the value in the Quantity column (This is a form) to increase or decrease incrementally by 1. Additionally, I would like the "Add Item" button to create a new line with the same form fillings, and the export button to take data created on the form, and make an Excel or csv file based on the list created. Any help to get started would be great. Thanks!

Categories:

Building Power Apps

If you're looking to dynamically add items, you'll need to use a Gallery control because Forms can only handle one item at a time.

Your idea is quite simple but does require some extra effort, so I'll give some suggestions instead:

Use a Gallery to display a collection with columns for Description, Unit, and Quantity. Initialize the collection with an initial row of data.
Each time the user clicks "Add item," collect a new row with initial data and add it to the current collection.
Each time user update value, in OnChange property use Patch the value to the collection
For the increase value button, use the Patch function to update the current quantity value of that item.

For the export function:

If you need to save the data to a database, create an automated flow that exports the data from your database to CSV and sends the CSV back to Power Apps for download. After submitting the data to the database, run the flow.
If you don't need to save the data to a database, compose a JSON object and send it to Power Automate. Then, parse the JSON object into a CSV file and send it back to Power Apps.

---------------------------

If the solution I provided assisted you in resolving this issue, kindly select "Accept as solution" This will help others in finding the solution more expediently 😄Also, a Thumbs up would be a great compliment!