Hi all,
I had created an app using a table in Dataverse and Power App studio created 3 screens automatically. The table in used for creating the app is MainTable.
Inside MainTable, there are columns that are link to other tables, eg. ProjTable and TypeTable.
The autogenerated Browse Gallery search and sort the results by other columns in MainTable, but what i needed the app to do is to display results and sort by ProjTable and TypeTable. But the Browse Gallery cannot display anything.
| MainTable | | | |
ProjectID (Data Type: LookUp, Table: ProjTable) | PIC | Feedback | Type (Data Type: LookUp, Table: TypeTable) |
| Proj1 | Staff1 | Feedback eg | Type1 |
| Proj2 | Staff3 | Feedback eg | Type2 |
| Proj3 | Staff2 | Feedback eg | Type1 |
| ProjTable | | |
| ProjectCode | Info | Value |
| Proj1 | Project at ABC | $123 |
| Proj2 | Project at DEF | $345 |
| Proj3 | Project at XYZ | $321 |
| TypeTable | |
| Type Code | Score |
| Type1 | 321 |
| Type2 | 234 |
| Type3 | 543 |
Items = fx
SortByColumns(Search([@MainTable], TextSearchBox1.Text, "cr232_ProjectID","cr232_Type"), "cr232_ProjectID", If(SortDescending1, Descending, Ascending))
The above command line will not have any result.
But if change to
SortByColumns(Search([@MainTable], TextSearchBox1.Text, "cr232_PIC","cr232_Feedback"), "cr232_PIC", If(SortDescending1, Descending, Ascending))
The gallery will be populated with search results.
Please advise what is the issue here? Anyway to get the Browse Gallery to search and sort based on the Project instead?
Best regards.
