Hello,
I have an Agreement SP list which contains agreements and the projects linked to them, projects are lookup columns that reference the projects in my projects sharepoint list which has an ID_Project and Description.
I have a table "ProjectsWithoutDescription" that simply distincts and filters my ID_Project data from the Agreement SP list based on the agreement the user had selected in my powerapp. e.g. Agreement AG0001 was selected, the list contains the project values "P00002" and "P00003"
I'm trying to get the "Description" value for each ID_Project based on the values in my "ProjectsWithoutDescription" list as well as the ID_Project since I need both values to put them in a gallery so that users can search based on either ID or Description.
The commented text in one of the attachments are some of my attempts at retrieving the data.
