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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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,

 

1 REPLY 1
amitchandak
Super User
Super User

@Anshenterprices , I think the question is for the power app? Not for power bi?

 

 

refer if this can help

https://www.youtube.com/watch?v=LxuRzj0X348

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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