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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

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.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (1,674)