cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SoSoDef276
Helper I
Helper I

Powerapps - MS Teams Build - Gallery Filter

Hello all, 

 

I spent hours trying to figure out how to filter the gallery but it just won't work. I am creating a simple Powerapp and publishing it to Teams. 

Here is the last one I tried; 

Filter(PRS,Resolved.value= "No")

 

PRS is the datasource

 

Resolved is choice field but when I click on it this appears "Choices('Resolved (PRS)')" I tried using this as well but it did not work. 

 

Can anyone help ?

 

9 REPLIES 9
JR-BejeweledOne
Super User
Super User

What is your items formula in your gallery?



If you like this post, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.
SoSoDef276
Helper I
Helper I

Sorry clicked Accept As Solution in error ; 

Is this what you are referring to ?

SoSoDef276_0-1612640112900.png

 

JR-BejeweledOne
Super User
Super User

When you tried that last formula where there any errors, red lines etc.?



If you like this post, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.
SoSoDef276
Helper I
Helper I

This is what I get ; 

 

SoSoDef276_0-1612641725904.png

 

SoSoDef276
Helper I
Helper I

Here is another one I just tried. 

 

Filter(Choices('Resolved (PRS)'.value = "No")

 

no luck -- seems to be an issue @ .value

SoSoDef276
Helper I
Helper I

I should also mention I am trying to filter based on the value of a datacard .

 

 

JR-BejeweledOne
Super User
Super User

Dataverse is a different kind of animal.   I am going to presume that your data is in a Dataverse entity?   If so, open Power Apps from Teams, and click on the Build option at the top of the screen.  You should see your tables there.   Open your PRS table and look at the 'Name' column.

 

This will show you your column names preceded by a unique identifier.    See picture below.

 

dataversetable.png

 

 

Sometimes you have to refer to that column using that name and not the 'Friendly' name you gave the column.

 

I would try that first.   

 

Filter( PRS, xxxx_Resolved.value = "No")



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

Tried that and it didn't work ; 

 

SoSoDef276_0-1612651953164.png

 

Is there something I need to do with default ? and look up ?

 

JR-BejeweledOne
Super User
Super User

I am going to recommend you watch this.    I think he talks about choice columns in Dataverse.  

 

https://youtu.be/o-0s3Pqh0TI



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

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (72,572)