Gallery1.Items: Filter(Documents, Employee = ) I'm also updating the TemplateFill property of the gallery to highlight the selected item, to make it easier for the user to see which document is being displayed. And in the text box inside the gallery we list the document's topic. Now in the gallery we can filter the Documents data source to show only those that are related to the selected employee. Here are the formulas that you can use to create this app.įor the dropdown, you want to select the employee names, so you can use the Distinct function to list the employees: Dropdown1.Items: Distinct(Documents, Employee) Where when you select the employee in the dropdown (top-left), it will update the list of PDFs associated with that employee (bottom-left), and then you can choose a document that will be displayed (right). If I understand you correctly, you want an app that looks somewhat like this: For your scenario, I'll assume that you have the data about the employees and the PDF documents that you want to show in a table, like in the example below (here I have an Excel file with a table called 'Documents', but other data sources would work the same) PowerApps does have support to show PDF files.

Open cdf files