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

insert/update/delete 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,

 

2 REPLIES 2
smpa01
Super User
Super User

@Anshenterprices you need to use SSIS/ADF for upsert/delete

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs
lbendlin
Super User
Super User

You may want to post your question in the PowerApps forum.  Power BI is not very good at writing data back reliably.

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