Filtering Dropdown list using data from a Gallery that is loaded

[Jebediah]

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.

[Jebediah · Accepted solution]

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

[eka24]

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

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

Or

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

Or

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.