cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anshenterprices
Helper I
Helper I

Bulk insert based on the column fields

Hi Team, 

I have 3 tables

1)

demat account table
dematiddematcodedemataccountname
4shrSharkhan
5zrdZRD
6ktkkotak
7angangel

 

 

2) 

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


3) 

Revenuetable
autogenrated id      
RevIDsegmentidsegmentnamedematcodedemataccountnameRevenueDate
11Equity4Sharkhan1231/18/2022
22Commodity4Sharkhan2341/18/2022
33Currency4Sharkhan3451/18/2022
44MF4Sharkhan4451/18/2022
55Cash4Sharkhan2421/18/2022
66Del4Sharkhan4331/18/2022
77Fut4Sharkhan3451/18/2022
88opt4Sharkhan4231/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

segmentidsegmentnamedematcodedemataccountnameRevenueDate

 
@ThatAPIGuy 


Thanks

2 REPLIES 2
v-JessicaG-msft
Community Support
Community Support

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:

 
vJessicaGmsft_1-1642757634506.png

 

 

Best Regards,

Jessica Gu

Anshenterprices
Helper I
Helper I

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

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (2,047)