Hello. With the announcement of Access Web App's retirement I am struggling to recreate my app using Power Apps. Is it possible to have a gallery and a form on a single screen where the form returns multiple records from one table (Table B) based on what is selected from the gallery (Table A) using SharePoint lists as my database.
I have two tables: A.Lessons and B.Projects where A.ATRF_ = B.ATRF_ (both are numeric columns)
I've tried inserting the gallery which queries from Table A and then I insert a display form using Table B with a filter formula as follows:
Filter(Lessons,Gallery1.Selected.ATRF_ = ATRF_)
This generates the error "The property expects Record Values, but this rule produces incomptable table values"
I've also tried the lookup and search formulas. The lookup formula does not seem to produce multiple rows in the results and the search formula doesn't seem to join the two tables.
