How to ClearCollect items with a specific value

[LukeWilkins6]

Hi,

I am trying to clear collect from a Sharepoint list but I only want the records with the same value. 

I have 10 records, 3 of which are linked to my username, but they have different data in another column (just a single line of text).

I need to be able to pull these 3 columns and their data, and hopefully put this data into a drop down.

Is this actually possible in PowerApps as I cannot seem to find the best way to do this.

Any help would be greatly appreciated!

[BrianS]

You may be able to use the Groupby function 

It will return a table with the records that have the same value in a certain column 

[v-jefferni · Accepted solution]

Hi @LukeWilkins6 ,

If you would like to populate the filtered items into a Dropdown Items, you could directly Filter the list in Items of the Dropdown:

Filter(YourList, UserName = User().FullName)

In this way it will be easy for you to get any column values by using Dropdown.Selected.OtherColumns from the selected item of the Dropdown. 

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.