This is my first post, and I do not profess to being anything other an amateur with PowerApps, that said I have successfully developed some apps which work fine and have some experience of coding in other applications.... but this one is frustrating me.
I have the below filter which is returning a single line of a table, however, there are 4 values in the collection JTMAdd, however I seem to have to invoke the First function on the filter to get the lookup values back from the required training. What I really want is table of ALL training courses that match the required training of all 4 values in the collection JTMAdd.
Filter('Training Courses', 'Course Title' in Filter(Choices('TM Roles'.'Required Training'), Value in First(Filter('TM Roles', Site.Value = DataCardValue22_1.Selected.Value, Title in JTMAdd).'Required Training').Required_x0020_Training.Value).Value)
The list Training Courses holds a list of training courses and relevant information, the TM roles list has a lookup column to select the relevant training courses against a role (in the field Required Training), JTMAdd holds a list of additional roles selected against a person which is to matched against the Title column. So overall in this case there should be 4 rows of a table returned of which I then need to check each row's Required Training and return all the training courses for all four rows to a single table.
The collection has 4 rows in it with a single value in each (see below). In formal coding I would using something like a for each function, but that does not appear to be available in Powerapps.
Any help would be appreciated.
Thanks
