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

Bulk insert based on the multiple rows by using gallary

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

1 REPLY 1
v-jefferni
Community Support
Community Support

Hi @Anshenterprices ,

 

I found a similar case from you:

Bulk insert based on the column fields - Power Platform Community (microsoft.com)

Please do not post same threads in a short period of time.

 

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

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,304)