Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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,
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.