Hello,
I have two SharePoint lists as my data source - one for each gallery. The second gallery is linked to the first via a SharePoint look up column.
I am trying to build a scenario where once the parent is selected from the first gallery (ProjectsListGallery), the children should appear on another screen. After selecting a parent on the first gallery, I then click a button which navigates me to the second screen where I should see its children in the gallery on this screen (MROListGallery). However when I select the parent and click the button to take me on to the next screen where I should see the children, I do not see anything on the gallery.
PowerApp has two screens - 1) Projects Screen 2) MRO Screen and two data sources (Projects list and MRO list).
Here is the function I am using: Filter('MRO list', 'Invoice Number' = ProjectsListGallery.Selected.'Project ID')
The Project ID column is the look up column on the SharePoint list.
What would be the formula to filter the MROGallery control so that it shows only the items related to the selected Project?
I would be really grateful if someone could help me out.
Thanks and regards
