Power Platform Community Forum Thread Details

I have a powerapps application with two screens. In the first screen there is a gallery with a column that is connected to a sql table named app journey. App journey has two columns named App name and Id. In the gallery in first screen there is a App name column that is filled with the text inputs that have the application names from the app journey. There is also a select column filled with check boxes in which if you select a checkbox it selects the application on the same row with the checkbox with it. Then when you click on a button the same screen it takes the row of the clicked checkbox and makes it the selected. The button then navigates you to the second screen. In the second screen, there is a gallery connected to a sql table named app stakeholders. On the second screen, the gallery has two columns named Name and role. Column role has combo boxes and column name has text inputs. The two tables and screens are connected in a way such that for example, there is a column named ID in app journey in with values such as 1, 2, 3, 4, 5 and the value is related to the application name. The ID is assigned to each application name in order. So the second row would have application name - cockpit and ID - 2 because it is in the second row and the fifth row would have application name - jealousy and ID - 5 because it is in the fifth row. This is connected to the app stakeholders such that there is a column named AppID that has the same values but there is another column named role that works in a way that there could me AppID with a value of 2 but it has multiple rows because the application cockpit has multiple roles such as manager, engineer, architect and so on. So, I want the second such as the selected checkbox or application's roles shows in the role column's comboboxs' default. For example, let say I choose on cockpit and go to the second page, I want the role column to show me the roles that have the value 2 in the AppID in each combo box.

Categories:

Building Power Apps