I have related tables in dataverse:
Table A (Parent):
| TimeSheetId | |
| 1 | |
| 2 |
Table B (Child):
| TimeSheetId | |
| 1 | |
| 1 | |
| 1 | |
| 2 | |
| 2 |
I need to filter a gallery that displays the items from table B, to only show either the parents TimeSheetId 1 or 2. My PowerApp allows the user to click a parent item (in a gallery), it then navigates to another gallery that should show all items from the selected parent item (1 or 2).
I am storing the selected parent TimesheetId in a variable and using it within the below function to filter the datasource:
Filter(TimesheetProjectWorks, varTimesheetId = TimesheetId)
but I'm getting incompatible types, these can't be compared Text, Record). How to filter a dataverse table displaying in a gallery?


Report
All responses (
Answers (