Unanswered

Bulk insert based on the column fields

(0) Share

Report

Posted on by 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

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

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

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

v-JessicaG-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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 26 on at

Like
a
(0)

Report
Copy link

Link copied!

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