Power Platform Community Forum Thread Details

I have a Excel powered Gallery which displays a list of equipment,
The table has an InputSelector which then shows on every row of equipment,
The aim is that the user sets the value of the number to the equipment and amount they want and submit it which creates a request and submits that request as a table to the excel sheet.

This works if user only wants 1 type of equipment,
However if more that 1 row of equipment has an Input number of greater than 0, aka the user wants it, Only the first selected equipment is stored.
So if user selects Laptop by changing the input number to 1 and also a Charger by changing the input number to 1. Only the laptop is added to the request.

Here is the code i have or the submit form.

Patch(
 SelectedTable,
 Defaults(SelectedTable),
 {
 DateTime: CurrentDateTime,
 Ticket: Text(TextInput_Ticket.Value),
 Equipment: If(
 IsError('Stock table'.Selected.Equipment),
 "",
 Text('Stock table'.Selected.Equipment.Text)
 ),
 Quantity: NumberInput_Equipment.Value,
 Requester: "",
 Fulfilled: "No"
 }
);

I've been unable to find any way to iterate through all the columns, i seem to be having issues with the fact its technically 1 NumberInput, but it shows on each row and can be modified independently.
Ive tried CoPilot and ChatGPT but I've hit a brick wall.

Any help is appreciated, sorry

Categories:

Building Power Apps