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

(0) Share

Report

Posted on by 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

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

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,

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@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.

Was this reply helpful? Yes No
Anshenterprices 26 on at

Like
a
(0)

Report
Copy link

Link copied!

@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-form/m-p/1415456#M367637

Was this reply helpful? Yes No