Hi all,
I'm totally new to PowerApps and I'm sure there is a very simple explanation for my problem but I simply could not find a solution after trying to research it on my own.
Data:
I have two tables stored in the same SQL database with a relationship:
KPI_Dim
KPICurrent_Fact (reffering the KPI_Dim via a Foreign Key 'KPI_key')
Goal:
I'm trying to edit the 'Value' and 'Score' data of the 'KPICurrent_Fact' table based on the selected item from the 'KPI_dim' table in the gallery.
The data in the gallery is populated using PowerBIIntegration.Data and displaxying the data 'Name', 'Description' from 'KPI_Dim' and the current KPI value from 'KPICurrent_Fact'. (Please see attached screenshot)
The data source of the edit form is the 'KPICurrent_Fact' table from the SQL database.
I tried to use Gallery.Selected but this does apparently not work when the data is stored in different tables in the database. I receive the error shown in the screenshot.
My best guess would be to use the lookup function to point to the primary key of 'KPI_dim' that is selected and in that way retrieve the current values from 'KPICurrent_Fact' but I cannot get it to work.
Any help is much appreciated!!!
