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

Filtering Dropdown list using data from a Gallery that is loaded

Hey guys,

PowerApps Noob here, Basically I have 2 Galleries generated from 2 different SharePoint list (Projects and Deliverables).


In the SharePoint list, when you create a deliverable, it pulls through the Project list and make you select one of the Projects Created initially.

I am currently able to generate all my projects in my first Gallery and everything is showing fine. What I am trying to accomplish is this :  I want to be able to use one of the value in a DataCardValue field that is loaded on the screen to filter a Dropdown list with .


I am currently using this code on the Items function of the DropDownList I want to generate the information in :

Filter(Deliverables, 'Project Name' = DataCardValue95.Text)


It's trying to pull a text value and it won't work. I have attached a screenshot of the error


Thanks for your help guys.


Accepted Solutions
Frequent Visitor

Solved the problem myself : Filter(Deliverables, DataCardValue95.Text = 'Project Name'.Value)

View solution in original post

Frequent Visitor

Solved the problem myself : Filter(Deliverables, DataCardValue95.Text = 'Project Name'.Value)

Super User
Super User

Try any of these depending on the formula on Items of DataCardValue95:


Filter(Deliverables, 'Project Name' = DataCardValue95.Value)


Filter(Deliverables, 'Project Name' = DataCardValue95.ColumnName)


Filter(Deliverables, 'Project Name' = DataCardValue95.Result)


If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.




Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (2,986)