insert/update/delete operation need to perform on SQL table by using power apps

[Anshenterprices]

Hi Team,

I have 3 tables

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

2)

College Branch
College ID	CollegeName	City
100	SBC	Pune
101	ABC	Delhi
102	HIND	Kolcatta
103	CUBE	Chennai
104	Forum	Banglore
College ID (Identity)
College ID Primary Key

3) 

RevenueTable
RevID	Dept_ID	College ID	Revenue	Date	UpdatationDatetime
1	1	100	100	11/1/2021	11/1/2021
2	2	101	105	11/2/2021	11/2/2021
3	3	102	110	11/3/2021	11/3/2021
4	4	103	120	11/4/2021	11/4/2021
5	5	104	130	11/5/2021	11/5/2021
6	1	100	140	11/6/2021	11/6/2021
7	2	101	150	11/7/2021	11/7/2021
8	3	102	160	11/8/2021	11/8/2021
9	4	103	170	11/9/2021	11/9/2021
10	5	104	180	11/10/2021	11/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 

RevID	Dept_ID	College ID	Revenue	Date	UpdatationDatetime
11	1	100	500	11/11/2021	11/26/2021 14:23:343

Thanks,

[amitchandak]

@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