Bulk insert based on the column fields

[Anshenterprices]

Hi Team, 

I have 3 tables

1)

demat account table
dematid	dematcode	demataccountname
4	shr	Sharkhan
5	zrd	ZRD
6	ktk	kotak
7	ang	angel

2) 

segmentTable
segmentid	segmentname
1	Equity
2	Commodity
3	Currency
4	MF
5	Cash
6	Del
7	Fut
8	opt

3) 

Revenuetable
autogenrated id
RevID	segmentid	segmentname	dematcode	demataccountname	Revenue	Date
1	1	Equity	4	Sharkhan	123	1/18/2022
2	2	Commodity	4	Sharkhan	234	1/18/2022
3	3	Currency	4	Sharkhan	345	1/18/2022
4	4	MF	4	Sharkhan	445	1/18/2022
5	5	Cash	4	Sharkhan	242	1/18/2022
6	6	Del	4	Sharkhan	433	1/18/2022
7	7	Fut	4	Sharkhan	345	1/18/2022
8	8	opt	4	Sharkhan	423	1/18/2022

requirement:-

i want to create a input form to generate the revenue table
initially revenue table is blank

a form contain
1)dropdown selection of dematcode column(from demat account table)
2) textinputbox of each segment .(from segment table) eg. 

Equity

Text input

Commodity

text input

3) submit button

Eg.  when user select dematcode(SHR) from the dropdown then after that user will insert the revenue in the text input field with receptive to each segment . once click on submit button 8 records will be added in the revenue table with

segmentid

segmentname

dematcode

demataccountname

Revenue

Date

 
@ThatAPIGuy 

Thanks

[v-JessicaG-msft]

Hi @Anshenterprices ,

You could use an editable grid in Power Apps, add the controls you need to the grid, and select the corresponding data source for the controls. Store the values of all selection controls in the collection each time, and finally use the patch function on the button to add the collection records to the revenue table.

You could refer to these links:

https://www.youtube.com/watch?v=8I0Pt_8I6k8

https://www.youtube.com/watch?v=wI6SHGQ9ATg

Best Regards,

Jessica Gu

[Anshenterprices]

@v-JessicaG-msft  in my actual table(segment table) there are more than 50 fields. 
also please confirm , if user wants to edit the fields in that case we need a separate entry for the updated column only whatever selected demat code(not for all column)