cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anshenterprices
Helper I
Helper I

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

Dml (insert/update) 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 ACCEPTED SOLUTION

Accepted Solutions
CNT
Super User
Super User

@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.

View solution in original post

2 REPLIES 2
CNT
Super User
Super User

@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.

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PWREduCon768x460.png

Join us at PWR EduCon - A Power Platform Conference

Learn from the top Power BI, Power Apps, Power Automate & Power Virtual Agents experts!

Top Solution Authors
Top Kudoed Authors
Users online (2,465)