Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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,
@Anshenterprices , I think the question is for the power app? Not for power bi?
refer if this can help
https://www.youtube.com/watch?v=LxuRzj0X348
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
109 | |
108 | |
108 | |
91 | |
61 |
User | Count |
---|---|
171 | |
138 | |
132 | |
102 | |
86 |