Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anshenterprices
Helper IV
Helper IV

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-easonf-msft
Community Support
Community Support

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors