Announcements
Good Day :),
Im currently trying to filter a gallery based on the foreign key which is entered in my table. im using the Typ:Search in the Table.
@Jan-Ph In the second gallery if you want to show the Project selected in the 1st gallery, the code will be,
Filter(Table2, ProjectID_ForKey=gallery1.Selected.ProjectID)
The data is not in gallerys. They are in dataverse Tables. I referred from one dataverse table to another dataverse table primary Key (As described above). I dont know how to access/read the Foreign Key it returns me errors.
I marked below in red which statement is not resolving me the correct data. The "xxxx" is just a basic string. I want to read the foreign Key (as an Text String) and then i want to filter it on "xxxx".
Filter(Table2, ProjectID_ForKey="xxxxx"
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 394 Super User 2026 Season 2
Mohsin Ali 328
WarrenBelz 324 Most Valuable Professional
