How to Build a Power App which populates multiple input boxes

[BhagyaPlus]

Hi, Power APP Team,

I am working on a project which has a requirement of the request form for a product procuring with all details of the product.

Hence there are chances that a request can be from a single Buyer with multiple product names and their details.

We thought of adding all details to the Excel Sheet and attaching to the Request form. But again it is tough to keep the record with ID.

Pleaseeee Suggest away so that a request form can take multiple inputs and has to be stored in the SharePoint list in a single shot.i., submitting a bunch of requests in a single shot by a single requestor.

EX: Attached

Help me out !!

Thanks

Bhagya

[FabianAckeret]

@BhagyaPlus 

Can you give us an example of a possible request form? Also, should the request be stored in a single item or multiple? If single (probably suggested), a column for each detail needs to exist. I can imagine that might not an ideal solution.

If I get it right, perhaps storing all products in a separate list and just referring to the request list with the ID of that product makes more sense. 

Anyway, if you could provide some more details about each stage, that'd be great.

[BhagyaPlus]

@FabianAckeret 

Thanks for your response.

Actually, I have attached an Excel Sheet to take all the details if the Request is for more than 10 Part Numbers.

The problem is if we are attaching the Excel, it's not a solution. I want to make the Work easy and want to get rid of the Excel Sheet.

It's ok if the request is stored in a Single Item like a single Request.

I have attached the screen Shot of our Form on which I am working.

Thanks

Bhagya