Filter a gallery populated with a Dataverse table

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Figured it:
Filter(TimesheetProjectWorks, varTimesheetId = ThisRecord.TimesheetId.TimesheetId)
Not entirely sure why it needed the extra TimesheetId on the end?

Was this reply helpful? Yes No