how to fetch the fields from the other data source with a single submit form

[Anshenterprices]

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

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,

[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,

[CNT · Accepted solution]

@Anshenterprices 

• The DataSource of your EditForm will be RevenueTable
• The Items property of the 'Deartment ID' DropDown will be 'DepartmentTable'
• The DisplayFields property of the 'Deartment ID' DropDown will be ["DeptName"]
• The Update property of the Datacard of the 'Deartment ID' DropDown will be Deartment IDDropDown.Selected.'Dept_ID'
• The Items property of the 'College ID' DropDown will be 'College Branch'
• The DisplayFields property of the 'College ID' DropDown will be ["College Name"]
• The Update property of the Datacard of the 'College ID' DropDown will be CollegeIDDropDown.Selected.'College ID'

Please remember to give a 👍 and accept my solution as it will help others in the future.

[Anshenterprices]

@CNT  can you please help me with the below post? :-
https://powerusers.microsoft.com/t5/Building-Power-Apps/instead-of-dropdown-create-a-separate-field-...