Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

ThisItem operator input based on dropdown

I have a Sharepoint list, which (among other columns), includes 28 columns that represent a different project. Rows (there are 80 of them) show the status of the project on a particular factory line. I don't want to show all the columns (fields) in the PowerApps Gallery. Instead, I made a dropdown box with the list of project names, which correspond to the headers of the project columns. Once a specific project is selected, I want the 80 rows to display the status for that project only.


In PowerApps, we would normally use ThisItem.[column name] to show values for all the rows, but how can I do it when the column name is based on the dropdown value (or a search box)? I can't find a solution to work with ThisItem operator. Is it possible?

Super User
Super User


Instead of ThisItem, you can set the Item property of a gallery or datatable as
Lookup(SPlist, ID = Dropdown1.Selected.ID)

Thank you for your reply. I cannot use LookUp either because I cannot filter by project names. The Project names are column headers (28 different headers). There is no column called Project, so I cannot filter by a project name due to the structure of the table.

Super User
Super User

Hi @UBek ,

I think you need to re-look at your data structure, or you will be hard-coding 28 possibilities every time you try to find a project.

Helpful resources

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (1,857)