Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.