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

Dml (insert/update) operation need to perform on SQL table by using power apps

Hi Team,

I have 3 tables

DepartmentTable
Dept_IDDeptName 
1HR 
2Finance 
3IT 
4KYC 
5Sales 
   
Dept_ID (Identity)
Dept_ID Primary Key


2)

College Branch
College IDCollegeNameCity
100SBCPune
101ABCDelhi
102HINDKolcatta
103CUBEChennai
104ForumBanglore
   
College ID (Identity)
College ID Primary Key

 

 

3) 

RevenueTable
RevIDDept_IDCollege IDRevenueDateUpdatationDatetime
1110010011/1/202111/1/2021
2210110511/2/202111/2/2021
3310211011/3/202111/3/2021
4410312011/4/202111/4/2021
5510413011/5/202111/5/2021
6110014011/6/202111/6/2021
7210115011/7/202111/7/2021
8310216011/8/202111/8/2021
9410317011/9/202111/9/2021
10510418011/10/202111/10/2021
      
 RevID (Identity)  
 College_ID Foreign Key  
 College_ID Foreign Key  

 


Requirment- I want to create a form to insert/update/delete records to the Revenue table by using power apps.
in the power apps with to create a dropdown selection with Deptname, college name and City

eg. once user select the "HR" and SBC and Pune from the dropdown then user should add the revenue value(500) and date(2021-11-11) in the textbox
then automatically it will insert the record in the Revenue table As 

RevIDDept_IDCollege IDRevenueDateUpdatationDatetime
11110050011/11/202111/26/2021 14:23:343

 


Thanks,

 

1 REPLY 1
v-eafang-msft
Microsoft
Microsoft

Hi, @Anshenterprices 

This seems more like a issue related to PowerApp Form control. I'm not an expert in Power Apps. 

You can check if these links are useful.

Power Apps visual for Power BI- PowerApps | Microsoft Docs 

Understand forms - PowerApps | Microsoft Docs

You can also post your question to the Power Apps Community for more professional help.

 

Best Regards,
Community Support Team _ Eason

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