Hi
I have constructed a PowerApp which works with data from two SharePoint lists. One of the lists holds the 'central' record/item. In the app, I've set up a screen where the end user can add one or more 'month' values to the central record - the 'month' values are stored in the second SP list (which I'm considering as the 'child' list). The link between the central record and the month values in the child list is via the ID - see below for screenshots of the two SP lists:
Main (central) list
'Child' list (holding the month values)
In a screen of the Power App, I want users to be able to see a list of 'Current items/records', this can be either a Gallery or Data Table. By 'current item', it should show any records in the current year (there's a field for 'Year' in the central list which we can filter on), and also any records where there is at least one month value for the current month (ie November for right now).
I can't work out how to do this using one Gallery/Data Table. I've set up one Data Table on the screen as below - this gets me the list of records pertaining to the current month from the child list:
For the above Data Table, I'm using this as the Items parameter:
Filter('Corporate WIP System - Month values', Text(Today(), "mmmm")in Month)
I've added a second Data Table, and can get it to work with the currently selected item:
By using this code:
Filter('Corporate WIP System test',Year(Today()) in 'Fiscal Year'.Value && DataTable3.Selected.Title in ID)
However, I want the second Data Table to show all items, not just the item that links to the selected one in the first Data Table. I cannot figure out how to do this. I've tried the same concept with a Gallery and can't get it to work.
I wonder if the Collections feature could be part of an answer, but I can't figure out how to go about doing it. Any help/advice would be much appreciated.
